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.

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.

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.