Good question. Not sure why it's worth 2 points; knowing that TRUNCATE can be rolled back should be elementary knowledge.
Abrar Ahmad_ (4/22/2010)
[font="Verdana"]Goodish, easy hunt. but for the only SQL Server 2008 users.:-D[/font]
Why is it only for SQL 2008 users? You are not supposed to answer by running the code, but to guess based on your knowledge. If you follow announcements and read articles, you know about the new INSERT syntax in SQL2008. (But it would have been better if the words "SQL Server 2008" had been included somewhere in the question).