Viewing 15 posts - 1,306 through 1,320 (of 7,636 total)
Glad I could help, Phil. 🙂
December 3, 2009 at 12:12 pm
JC-3113 (12/2/2009)
i treied to implement and am getting errors on execution:
Msg 102, Level 15, State 1, Server NSAB-SS80-SQL-N, Line 262
Incorrect syntax near '-'.
Msg 102, Level 15, State 1, Server...
December 3, 2009 at 12:06 pm
RBarryYoung (12/1/2009)
Check to see if there any DENY's in that database.
As Steve and I have both said, this is what you need to look for.
December 3, 2009 at 12:03 pm
sandeep singh-337370 (12/2/2009)
Dear Sirs,This is a CRM application and sending mail is part of the application. we are not using sql mail or db mail.
Then this almost certainly a...
December 3, 2009 at 11:50 am
Elliott W (12/1/2009)
December 1, 2009 at 4:32 pm
Check to see if there any DENY's in that database.
December 1, 2009 at 4:30 pm
PiMané (12/1/2009)
...SELECT .. INTO it's not a very good idea unless the table you're creating has few rows.
...
No, this is incorrect. It's a holdover myth from SQL2000 or...
December 1, 2009 at 4:19 pm
AFAIK, this is very hard to do with TSQL alone. It's much easier to do from another facility (DOS, Powershell, SMO w VB or C#, etc...) and then bring...
December 1, 2009 at 3:41 pm
dmounday (11/18/2009)
Interesting description of a cursor..."the bastard love child..."
Heh. Yeah, that's what happens when I take my meds before I start writing. 🙂
December 1, 2009 at 3:34 pm
Jack Corbett (11/18/2009)
...Also check out R. Barry Young's series (2 parts so far) on 15 Ways to Lose Your Cursors. Part 1 here[/url]
Hey, thanks for the plug, Jack! ...
December 1, 2009 at 3:32 pm
BaldingLoopMan (12/1/2009)
If you were writing a proc that was supposed to run a log backup command on each active database in Full recovery model, which is a situation where you...
December 1, 2009 at 3:28 pm
GSquared (12/1/2009)
Lynn Pettis (12/1/2009)
jdurandt (12/1/2009)
@Lynne - I agree 100% : Set based processing is the answer in 99% of cases. What I was saying though is that,...
December 1, 2009 at 3:18 pm
Alvin Ramard (12/1/2009)
CirquedeSQLeil (12/1/2009)
Simply amazing how quiet the.Thread is today....The Thread fell asleep at Thanksgiving and has yet to wake-up completely. ....
Probably eating too many Turkies...
December 1, 2009 at 3:06 pm
Heh, right you are, Kevin.
December 1, 2009 at 3:03 pm
Glad I could help. 🙂
December 1, 2009 at 3:00 pm
Viewing 15 posts - 1,306 through 1,320 (of 7,636 total)