Just a day ago, I was wondering how many active transaction are currently in my database. I found following DMV very useful - very simple and to the point.Following SQL will return currently active transaction.SELECT * FROM sys.dm_tran_session_transactions Reference : Pinal Dave (http://www.SQLAuthority.com)...
Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
