RSS feed

SQL Query to Find List of Open Connection Objects in MS SQL Server

Published by: Lisa (12/7/2009 3:41:21 PM)

DEC 7 2009

I want to see all the connection objects that are opened in a single point of time. What is that sql query that i can write to figure out the answer? If you know the sql query that works with any version of MS SQL Server then that will be a real help to me.


Problem with sql server 2k >>

<< How to Write a Query to Search Multiple Strings From Multiple Columns



Name: San

SELECT DB_NAME(dbid) as ’DatabaseName’, COUNT(dbid) as ’OpenConnections’ from master.dbo.sysprocesses with (nolock) WHERE dbid > 0 GROUP BY dbid

You can use HTML tags here.
*Code: Please enter the sum of 5+2