the problem of @@TRANCOUNT--how to eliminate the no.266 error

williamchou

Mike Dimmick

Ensure that every use of BEGIN TRAN is matched with either a ROLLBACK TRAN or a COMMIT TRAN, regardless of whether an error occurs. In the case of a fatal error, SQL Server will roll back any transactions before it closes your connection. If you have implicit transactions enabled (through SET IMPLICIT_TRANSACTIONS ON) a BEGIN TRAN happens automatically the first time you perform any data modification operation. You still have to commit or roll-back this implicit transaction explicitly. Stability. What an interesting concept. -- Chris Maunder