Woooot! It's Friday alright!

You need to stop throwing slow pitch, Ed!

Of course, truncate cannot be rolled back IF THE DATABASE IS IN FULL
RECOVERY MODE. This is because truncate removes data by deallocating data
pages from the table, rather than individual rows.

HOWEVER, if the TRUNCATE statement is embedded in a transaction, the
database is not in full recovery mode and the session that the transaction
is participating in has not been closed, then you can roll back the
TRUNCATE.

Have a great day!

J. Cockrum
Productivity, Inc.

-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x51015935.[Email address protected]
Sent: Friday, February 29, 2008 9:02 AM
To: LazyDBA Discussion
Subject: RE: SQL Server Truncate Table

Well, well, well!
It's Fridayyyyyy! Partyyyyyyyy! Hehe. Not so fast! It's test
time! Hehe. Can you win "the COKE"? hehe.


Question: Truncate Table Cannot Be Rolled Back. True or False. As
usual, please provide proof! Hehe.



http://sqlblog.com/blogs/denis_gobo/archive/2007/06/13/1458.aspx


Please take a few minutes to provide feedback on the quality of service you
received from our staff. The Department of Education values your feedback as
a customer. Commissioner of Education Dr. Eric J. Smith is committed to
continuously assessing and improving the level and quality of services
provided to you.Simply use the link below. Thank you in advance for
completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page