Transaction ID

• Gaja Naik

  SSC Rookie

  Points: 38

  More actions

  March 9, 2007 at 12:46 pm

  #176507

  Hello All.. I am trying to develop a auditing module for my application without using triggers in .NET. As my application updates multiple tables in a transaction i want to get the transaction ID when i say BeginTransaction before the update  . By transaction ID i mean the ID that the SQL server generates which is unique.

  look at the transaction ID field in this when you execute this command

  DBCC Log(<databasename&gt

  is there any way to get this transaction id in sql server or .net

  Thanks

  Gaja

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 9, 2007 at 11:33 pm

  #694219

  In sql profiler/trace also you get the "system assigned id for a transaction"...

  I don't think transaction ids from dbcc log and profiler/trace are the same...

  MohammedU
  Microsoft SQL Server MVP