Embedded Files
SELECT
session_id,
open_transaction_count,
transaction_isolation_level
FROM sys.dm_exec_sessions
WHERE open_transaction_count > 0
BEGIN
BEGIN TRY
BEGIN TRAN
-- sql code
COMMIT
END TRY
BEGIN CATCH
ROLLBACK
END CATCH
END
Page updated
Google Sites
Report abuse