"Sleight of hand", not exactly, however it means you get to roll back your TRUNCATE statement??? With SQL Server (2000, and presumably 2005 - I've never tried it), you can turn the IMPLICIT_TRANSACTIONS ON or OFF. It is automatically set to OFF and thus you get the default autocommit mode upon completion of a transaction. Thus the use of a BEGIN TRAN - ROLLBACK TRAN - COMMIT TRAN block, if you want to be able to define a rollback capture event. If you set it to ON then you have to explicitly COMMIT your statements anyway, so what are you gaining? The fact that you have to state you want the transaction to commit? Sorry about the formatting of the reply, but the Mailer Daemon is being a COMPLETE WANKER today. Which for those of you not au fait with the full range of Anglo-Saxon is British English for Wanker.
Jeremy Greaves
Fenris Software Consulting, Inc
MS Sql Server LazyDBA home page