Viewing 15 posts - 39,001 through 39,015 (of 49,571 total)
That's not built-in SQL error. The error number (50000) indicates that it's being raised in that procedure. Take a look through that proc for code like this, and see...
May 21, 2009 at 3:46 am
Tom Brown (5/21/2009)
You mean you don't count those headless voles, rat livers and mouse innards as wages.
Mine never bring me anything. Only once they brought a bird in and then...
May 21, 2009 at 3:38 am
sk.panda (5/21/2009)
Should the above command is the appropriate solution for Execution paln?
What are you trying to do? If you just want to see the query's exec plan, run it in...
May 21, 2009 at 12:21 am
Jan Van der Eecken (5/20/2009)
May 21, 2009 at 12:13 am
Constraints if possible, triggers only when the constraint can't be implemented. What you have there sounds like a standard unique constraint. If it's not, post more details.
May 21, 2009 at 12:12 am
Lynn Pettis (5/20/2009)
Bob Hovious (5/20/2009)
Gail: There's hope!Many people have cats but go on to live perfectly normal lives. 😛
As long as you remember this one...
May 21, 2009 at 12:04 am
Nope. If that doesn't work, it won't restore.
May 21, 2009 at 12:02 am
Lynn Pettis (5/20/2009)
Insanity is hereditary, you get it from your kids-- reference unknown
Edit: And for those without kids, I have no explanation.
Do cats count?
May 20, 2009 at 3:27 pm
Alex Prusakov (5/20/2009)
- A.STATUS='A' or A.STATUS IS NULL clause makes impossible to use any index by SQL Server;
SQL can use an index to satisfy that, depending (of course) on how...
May 20, 2009 at 3:11 pm
Grant Fritchey (5/20/2009)
May 20, 2009 at 10:35 am
josephptran2002 (5/20/2009)
Where can I find the SSIS or import/export wizard?
They're both part of SQL server.
can you send me a link of how to use it?
http://www.google.com/search?q=SSIS
http://www.google.com/search?q=%22Import+Export+Wizard%22+%22SQL+Server%22
Or perhaps you could...
May 20, 2009 at 9:44 am
Lynn Pettis (5/20/2009)
You know what? I think some of us (me included) really need a vacation in some far off exotic locale. Too bad I can't afford one...
Yup....
May 20, 2009 at 9:38 am
You cannot update an identity column. If you absolutely need to change some values, delete the row and then reinsert it specifying the identity value (with identity insert on)
May 20, 2009 at 9:34 am
naveenreddy.84 (5/20/2009)
Will using NOLOCK in the Stored procedure for SELECT State would provide performance beneficit?
Nolock is not a performance tool. It controls the accuracy of the data read by that...
May 20, 2009 at 9:33 am
I would suggest you contact customer support. It's not supposed to break.
May 20, 2009 at 9:33 am
Viewing 15 posts - 39,001 through 39,015 (of 49,571 total)