Viewing 15 posts - 1,066 through 1,080 (of 1,194 total)
wware (8/17/2011)
I also believe that truncate CAN be rolled back because of a couple QOTDs on the topic. Am I wrong?
Not wrong on that one - see...
August 17, 2011 at 11:28 am
jcrawf02 (8/17/2011)
I missed it because I couldn't decide on my second choice, and went with "truncate is not logged" assuming the author was making that common error (um, sorry Stuart).
No...
August 17, 2011 at 7:48 am
mbova407 (8/17/2011)
TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions.
True- key word there is individual - truncate can be rolled back (see earlier script...
August 17, 2011 at 6:53 am
rfr.ferrari (8/17/2011)
easy question!!
I would liked to have thought so - but sadly (and alarmingly) not so going by the right / wrong answers given - roughly 50/50 split
August 17, 2011 at 5:38 am
Brandie Tarvin (8/10/2011)
This one is giving me heartburn. I almost ran something in Production that was supposed to...
August 11, 2011 at 2:09 am
bopeavy (8/10/2011)
Ray K (8/10/2011)
Evil Kraig F (8/10/2011)
--------------------------------------------------------------------------------
bopeavy (8/10/2011)
--------------------------------------------------------------------------------
crookj (8/10/2011)
--------------------------------------------------------------------------------
bopeavy (8/10/2011)
--------------------------------------------------------------------------------
SQLRNNR (8/10/2011)
--------------------------------------------------------------------------------
Daniel Bowlin (8/10/2011)
--------------------------------------------------------------------------------
bopeavy (8/10/2011)
--------------------------------------------------------------------------------
SQLRNNR (8/10/2011)
--------------------------------------------------------------------------------
pitty
Hole
in one!!
Fore
Three, Two, One
Blast Off!!!
Major Tom
Can you heeeaarrrr meeeee.......
August 11, 2011 at 1:59 am
It took a while but I got there.
http://www.sqlservercentral.com/Forums/Topic1153528-338-1.aspx
Only took me a day to work it out!:ermm:
August 4, 2011 at 1:23 am
Case closed.
I am a klutz and didn't read my code properly. The BCP out command was coming from the prodution database and I was running the code in the development...
August 4, 2011 at 1:20 am
Contracting to me is a double edge sword, on one hand you have more money - but you are looking out for your next job half way through your contract,...
July 6, 2011 at 1:09 am
Until my QOTD gets posted, answered and questions raised about it - I'll keep quiet
June 29, 2011 at 8:56 am
Viewing 15 posts - 1,066 through 1,080 (of 1,194 total)