By StarkMike - 3/8/2007
I'm using transactions in .NET and i was wondering if there was a way to see when one was opened or started. Is there a SQL Server program or a .NET utility to watch the server and see when a transaction is started, etc.
Just curious.
|
By StrataFrame Team - 3/8/2007
I think there is a performance counter that you can hook into SQL Server to watch the number of transactions... when it increments, you'll know a new one was started. But other than that, I don't think there is an event or anything within SQL Server that will tell you when a new transaction is started.
|
By StrataFrame Team - 3/8/2007
Just do a google or msdn2.microsoft.com search for "performance counter sql server transactions" (without the quotes) and I'm sure you'll find something.
|