Hey,

TRUNCATE is DDL Command so It works with AUTO Commit option. So Data can
not be rolled back.

If you want to get data back after truncate also. That database should
have archieve and while recovery who should to Recovery with stop time.

Thanks, & ALL THE BEST

-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x14121083.[Email address protected]
Sent: Friday, February 29, 2008 6:17 PM
To: LazyDBA Discussion
Subject: RE: SQL Server Truncate Table

Hey Pete,
Oh my! Phew! Ouch! "No COKE" for you! hehe.

-----Original Message-----
From: Pete
[mailto:mssqldba-ezmlmshield-x96253610.[Email address protected]
Sent: Friday, February 29, 2008 7:44 AM
To: LazyDBA Discussion
Subject: Re: SQL Server Truncate Table

Nope!

But if did a DELETE FROM syntax it would be rollback-able

Edwards Ed wrote:
> 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.
>
>
> 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
>
>
>
>




---------------------------------------------------------------------
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



---------------------------------------------------------------------
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


***********************
No virus was detected in the attachment no filename

Your mail has been scanned by InterScan.
***********-***********


*********************************************************************************************************************************************************************
"This message and any attachments are solely for the intended recipient and may contain Birlasoft confidential or privileged information. If you are not the intended recipient,any disclosure,copying, use, or distribution of the information included in this message and any attachments is
prohibited. If you have received this communication in error, please notify us by reply e-mail at ([Email address protected] and permanently delete this message and any attachments. Thank you."
*********************************************************************************************************************************************************************

MS Sql Server LazyDBA home page