Named Transactions

• williamminor

  SSCommitted

  Points: 1664

  More actions

  September 24, 2009 at 12:07 pm

  #215619

  I'm having a discussion with some people at work at wanted some input for you sql masters.

  Is there a benefit to naming a sql transaction? other than being able to roll it back to a marker.

  Thanks

  -WM

• Grant Fritchey

  SSC Guru

  Points: 399009

  More actions

  September 24, 2009 at 12:22 pm

  #1058205

  It can be useful for troubleshooting. You can see the transactions by name if you select sys.dm_tran_active_transactions.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning