|
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
|
|
|
|
|
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@
|
|
|
|
|
Try updating your statistics, "UPDATE STATISTICS..." This may not do anything but it might help
|
|
|
|
|
|
Try logic; you renamed it?
Drop it, and create it anew?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
hi everybody I need to do something like that:
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.
|
|
|
|
|
Something like this should do the trick.
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
|
|
|
|
|
Add Group By ProductName, Field2
after the where clause
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
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.
|
|
|
|
|
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.
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]
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
What database server are you using?
|
|
|
|
|
|
|
You can also user the SQL import Export wizard to transfer the data from one database to other database either table wise of bulk
|
|
|
|
|
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
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Which is why you dont use SQL Authentication.
I feel your pain. Been there.
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|