Viewing 15 posts - 4,861 through 4,875 (of 7,636 total)
Thanks, Jeff. Will this work for a normal/unprivileged user also?
November 10, 2008 at 9:23 pm
Lynn Pettis (11/10/2008)
ajaykini (11/10/2008)
Barry:CTE works in sql 2005 and not in sql 2000 i guess.
I am having sql 2k as back end.
What is your advise
If you post in a SQL...
November 10, 2008 at 9:15 pm
Matt Miller (11/10/2008)
A TRY/CATCH in the calling context will deal with it. As long as you deal with it before the end of the batch you should be okay.....
Yes,...
November 10, 2008 at 9:09 pm
Lynn Pettis (11/10/2008)
November 10, 2008 at 8:55 pm
bhovious (11/10/2008)
What is supposed to happen if the second application (that is supposed to finish up) fails? Is SQL just supposed to wait forever?
There is only one...
November 10, 2008 at 8:45 pm
mcginn (11/10/2008)
This time when I executed the procedure on the sender side the error in the server log was from the activation procedure indicating ...
This is actually very good, because...
November 10, 2008 at 4:51 pm
Derek Dongray (11/10/2008)
I assume R.Barry Young was kidding ...
Not really, "Not Left(name,3) = 'sp_'" is actually what I use. I've never had a problem with it.
November 10, 2008 at 4:43 pm
You can find this in BOL(Books Online). If you still need help, then please start a new topic.
November 10, 2008 at 4:38 pm
Is this still not working? What is the current state of things?
November 10, 2008 at 4:36 pm
Just add:
And Not Left(name,3) = 'sp_'
November 9, 2008 at 8:04 pm
ankur (11/8/2008)
I mean to say that if x is NOT NULL then y.
Like this:
(CASE WHEN X IS NOT NULL THEN Y ELSE NULL END)
November 8, 2008 at 11:05 pm
I do not believe that there is any truly efficient way to do this for an accurate random distribution, however, the most efficient would almost certainly be an iterative Monte...
November 8, 2008 at 9:20 pm
Have you tried a FULL OUTER JOIN ?
November 8, 2008 at 7:28 pm
Heh. You know all of those answers looked OK to me. 🙂
November 8, 2008 at 12:03 pm
The purpose of ISDATE is to tell you ahead of time whether or not an attempt to CAST or CONVERT something into a Datetime format is going to suceed or...
November 8, 2008 at 12:00 pm
Viewing 15 posts - 4,861 through 4,875 (of 7,636 total)