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

-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x64225361.[Email address protected]
Sent: Friday, February 29, 2008 8:11 AM
To: LazyDBA Discussion
Subject: RE: SQL Server Truncate Table

I'd say you CANNOT roll back because it's non-logged operation.


Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)


-----Original Message-----
From: Edwards Ed [mailto:mssqldba-ezmlmshield-x14121083.[Email address
protected]
Sent: Friday, February 29, 2008 7:47 AM
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



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