In SQL Server 2000, Query Analyzer provided an Auto-rollback Debugging feature by using a checkbox.
I do not think that the workaround should be adding to all of the stored procs a begin transaction and ended with a rollback. This is prone to error.
Is this feature is availiable in SQL Server 2005 in a different form?
