Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones The DBA Whoops RE: The DBA Whoops
chopeen
Ten Centuries
Points: 1005
More actions
June 16, 2005 at 1:16 am
#565986
Sometime ago I created a Query Analyzer template like this:
BEGIN TRAN
/* queries go here */
-- ROLLBACK TRAN
-- COMMIT TRAN
--
-- SELECT @@TRANCOUNT
-- DBCC OPENTRAN
If I make any ad hoc changes, I always use it.