What are the differences?

• Reo

  Hall of Fame

  Points: 3774

  More actions

  July 30, 2010 at 4:29 am

  #227356

  Hi,

  I would like to interest to know in detailed about what are the differences in below mention SQL Server cmds:

  1. ROLLBACK TRAN Versus KILL <SPID>

  2. DBCC INPUTBUFFER Versus DBCC OPENTRAN

  Thanks! 🙂

  Ram
  MSSQL DBA

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 30, 2010 at 5:12 am

  #1200217

  Books Online is the best resource to get these details. However, you may refer these links.

  ROLLBACK TRANSACTION

  KILL

  DBCC OPENTRAN

  DBCC INPUTBUFFER

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga