Database Discussion Boards

Mycroft Holmes26-Nov-12 23:30

26-Nov-12 23:30

You probably renamed the proc and the sp_help has not refreshed the name.

If one of my devs named a proc like that he would get a first warning, there would be no second.

Never underestimate the power of human stupidity
RAH

Re: EXEC sp_helptext

jojoba201126-Nov-12 23:38

jojoba2011

26-Nov-12 23:38

Thanks in advanced but the sp was renamed before and now its working properly!
but when i right click the sp and click on modify is diffrent from sp_helptext. and event the name of it in sp list is also different from sp_helptext !

But i dont get why this is happing@

Re: EXEC sp_helptext

Corporal Agarn27-Nov-12 0:59

Corporal Agarn

27-Nov-12 0:59

Try updating your statistics, "UPDATE STATISTICS..." This may not do anything but it might help

Re: EXEC sp_helptext

jojoba201127-Nov-12 3:09

jojoba2011

27-Nov-12 3:09

thanks but no use ...
on google :
should update :sys.object/sys.storedprocedures/sys.sql_modules

https://www.google.com/search?hl=en&tbo=d&q=sp_helptext+renamed+stored+procedures++%2B+sql&oq=sp_helptext+renamed+stored+procedures++%2B+sql&gs_l=serp.3...8091.13502.0.13693.20.20.0.0.0.0.488.3055.7j7j2j2j1.19.0.les%3B..0.0...1c.1.MmW-E40j8mE[^]

I dont know how

modified 27-Nov-12 9:20am.

Re: EXEC sp_helptext

Eddy Vluggen27-Nov-12 13:33

Eddy Vluggen

27-Nov-12 13:33

Try logic; you renamed it?

Drop it, and create it anew?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

RECORD VALIDATION IN ACCESS

teto26-Nov-12 5:19

teto

26-Nov-12 5:19

HOW TO MAKE ACCESS CHECK THE WHOLE RECORD FORM THE OTHER TABLES
I WANT TO CHECK THREE FIELDS IN TABLE FROM ANOTHER TABLE DURING DATA ENTRY

Re: RECORD VALIDATION IN ACCESS

André Kraak26-Nov-12 5:56

André Kraak

26-Nov-12 5:56

DO NOT SHOUT when asking a question. When you use all capital letters it is seen as shouting on the Internet and considered rude. Next time when posting a question please use proper capitalization.

0100000101101110011001000111001011101001

Re: RECORD VALIDATION IN ACCESS

Corporal Agarn26-Nov-12 6:05

Corporal Agarn

26-Nov-12 6:05

What have you tried?

how to compare an operation in where expression In sql

GREG_DORIANcod26-Nov-12 4:29

GREG_DORIANcod

26-Nov-12 4:29

hi everybody I need to do something like that:

SQL

select x.ProductName, sum(x.field1+y.field2) as Mysum, y.field2 from tablexxx as x inner join tableyyy as y on x.id =y.id where as Mysum - y.field2 > 0

obviously it doesnt work!, but I'm looking for suggestions

modified 26-Nov-12 10:42am.

Re: how to compare an operation in where expression In sql

s_magus26-Nov-12 5:20

s_magus

26-Nov-12 5:20

Something like this should do the trick.

SQL

Select ProductName, MySum, field2
From   (Select x.ProductName, SUM(x.field1 + y.field2) as MySum, y.field2
        From tablexxx as x inner join
             tableyyy as y on x.id = y.id) as q
Where MySum - field2 > 0

Re: how to compare an operation in where expression In sql

Mycroft Holmes26-Nov-12 11:56

Mycroft Holmes

26-Nov-12 11:56

Add Group By ProductName, Field2
after the where clause

Never underestimate the power of human stupidity
RAH

grant permission on table in another database

Danzy8326-Nov-12 3:55

Danzy83

26-Nov-12 3:55

Hi everyone! I need to grant permission on a table in a database to a database role in another database.

I have client database containing information about clients. In another database, I have roles for different departments. Now I need to grant permission on specific tables in the client database to roles or departments which are located in another database.

I have been struggling for a solution but have not succeeded. Is there any way to accomplish this task? Please help.

Re: grant permission on table in another database

Chris Meech26-Nov-12 8:25

Chris Meech

26-Nov-12 8:25

Dan_K wrote:
Now I need to grant permission

Is some kind of permission problem ocurring now that wasn't occuring before? Maybe I'm missing the obvious. Smile | :)

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

How to mearge local database with server database

Jitendra Parida - Jeetu23-Nov-12 22:00

Jitendra Parida - Jeetu

23-Nov-12 22:00

I use two database one is local server because there internet is not available. another is on global server my problem is that how to update local database on global database.

Re: How to mearge local database with server database

Mycroft Holmes23-Nov-12 22:17

Mycroft Holmes

23-Nov-12 22:17

Do some research into "replication" this may meet your needs or you can script the data transfer. There is no simple way to "merge" 2 databases. You may also look into Data Compare from Red Gate but I don't think that is going to be the tool.

Never underestimate the power of human stupidity
RAH

Re: How to mearge local database with server database

Corporal Agarn25-Nov-12 2:48

Corporal Agarn

25-Nov-12 2:48

What database server are you using?

Re: How to mearge local database with server database

Jitendra Parida - Jeetu25-Nov-12 18:13

Jitendra Parida - Jeetu

25-Nov-12 18:13

sql server 2008 r2

Re: How to mearge local database with server database

GREG_DORIANcod26-Nov-12 5:56

GREG_DORIANcod

26-Nov-12 5:56

Try Sync Framework

http://msdn.microsoft.com/en-us/sync/bb736753.aspx[^]

Re: How to mearge local database with server database

Deepak Kr128-Nov-12 1:31

Deepak Kr1

28-Nov-12 1:31

You can also user the SQL import Export wizard to transfer the data from one database to other database either table wise of bulk

Stupid bloody idiot

Mycroft Holmes18-Nov-12 21:25

Mycroft Holmes

18-Nov-12 21:25

Yeah that's me, I have sql server express installed on my local machine so I can test stuff without polluting the development server. So I have not needed it for ages, not trying anything new on a database level recently.

Well now I want to create a test database and I mislaid the blasted sa password and I don't have enough rights on the dammed thing. Apparently the only was is to re install the database Gggrrrr Mad | :mad:

Never underestimate the power of human stupidity
RAH

Re: Stupid bloody idiot

J4amieC18-Nov-12 22:39

J4amieC

18-Nov-12 22:39

Which is why you dont use SQL Authentication.

I feel your pain. Been there.

Re: Stupid bloody idiot

Richard Deeming19-Nov-12 1:46

Richard Deeming

19-Nov-12 1:46

Alternatively, if you're a local administrator, you can restart SQL in single-user mode, log in using Windows authentication, and either reset the sa password or add yourself to the sysadmin role.
http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Stupid bloody idiot

Mycroft Holmes19-Nov-12 11:43

Mycroft Holmes

19-Nov-12 11:43

Now that I did not know, have 5 for he link, thank you, you have justified the rant...

Never underestimate the power of human stupidity
RAH

mhd.sbt18-Nov-12 21:11

mhd.sbt

18-Nov-12 21:11

hi every buddy
i hav e a problem to create new user in sql server 2008 r2
i create a user and my user created.
and i logined with this user succesfully. but when i want to create a new database in sqlserver authentication mode
i facing with this problem

"Create Database permission Denied in DataBase master.[error 262]"
thanks for any help.

Re: login with another user faile problem

Mycroft Holmes18-Nov-12 21:20

Mycroft Holmes

18-Nov-12 21:20

You need dbo permission on the Master database (I think) to be able to create a database. Do some research on what permissions are available in SQL server it will be very enlightening.

Never underestimate the power of human stupidity
RAH

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.