Other SQL Server Blogs around the Web

Browse by Tags

• connections
• dmv
• new features
• sql server
• sysprocesses
• transaction
• tsql

• TSQL to get list of operations in active transaction of the current session

  SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever... Posted Jan 27 2010, 07:46 AM by <P>SqlServer-QA.net</P> Filed under: dmv, sql server, tsql, transaction, new features, active

• SQL Server: Quick way to find Active & idle connections on a SQL instance

  Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system... Posted May 02 2008, 04:32 AM by SSQA.net Filed under: dmv, sql server, tsql, connections, transaction, active, sysprocesses