Hi!

I would need a way to get the current transactionID of the connection (Sql Server 2000 SP3).

The reason for this is that want to create triggers on some tables which write update-, insert- and delete- history into another table from where this change history (only the committed entries) is picked up for notification to another service and I want to notify changes grouped by transaction so that the subscriber of this notifications doesnt get inconsistent data.
I am not using replication for this because the changes should be transmitted as fast as possible.

I didnt find such a connection property or function for reading the current transation ID in the BOL so far.

Does anybody know how such transaction ID can be read in T-SQL if this is possible at all ?

regards FZ

MS Sql Server LazyDBA home page