Hey chandrashekar,
Oh my! Phew! I'm back from my meeting! Ouch! Hehe. Ahhhhhhhhhh,
"No COKE" for you! hehe.


-----Original Message-----
From: chandrashekar
[mailto:mssqldba-ezmlmshield-x53982221.[Email address protected]
Sent: Friday, February 29, 2008 7:54 AM
To: LazyDBA Discussion
Subject: RE: SQL Server Truncate Table



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."
************************************************************************
************************************************************************
*********************


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