When a stored procedure exit, if @@TRANCOUNT is not the same as it had when the procedure started, SQL Server raises error 266. Unfortunately, Microsoft considers this error is not fatal, it's not easy for us to troubleshoot which stored procedure is the
culprit. Is there a way to log this error in SQL Server log?
View Complete Post