Viewing 15 posts - 1,066 through 1,080 (of 1,195 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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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.......
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 11, 2011 at 1:59 am
paranoia
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 4, 2011 at 9:33 am
Thanks!
I'm only 25 as well 😛
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 4, 2011 at 9:02 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:
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 4, 2011 at 1:20 am
stiletto
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 4, 2011 at 1:04 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,...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
July 6, 2011 at 1:09 am
Blues
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
July 5, 2011 at 1:55 pm
Until my QOTD gets posted, answered and questions raised about it - I'll keep quiet
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 29, 2011 at 8:56 am
senna pod
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 24, 2011 at 11:25 am
Viewing 15 posts - 1,066 through 1,080 (of 1,195 total)