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.

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.