>
>Well, if you want a better link you may want to read this article
>
>http://social.technet.microsoft.com/wiki/contents/articles/24130.miss-understanding-of-truncate-command.aspx


Actually, if you read the contents of your 2nd link, and go back and read one of my paragraphs, you'll note they both cover the same thing (the rollback and logging issue), though obviously the link covers the details of the log sequence numbers and operations going on under the hood

>
>I was not sure what was the reason for Mike's question - was it because he didn't know the command? And BTW, BOL reference is always a good answer - if there are extra questions after reading that link, then I can clarify them. Unlike .NET help which I often find very short and hard to get the right information, BOL offers comprehensive answer with good examples.

BOL reference is usually good as a reference. But it won't always cover the nuances. And besides - you never know when you might be asked the question away from the online world and there's hope you'll have an answer. So it's good to keep in practice. :)