CATEGORIES
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.
Most Popular Articles
- SQL Server 2008 Error: is not a valid login or you do not have permission
- Cannot start .aspx
- what is the difference between Text and String Data type in SQL Server
- Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
- Why my MS SQL Server 2005 DSN Connection is not Working
<< How to Write a Query to Search Multiple Strings From Multiple Columns
COMMENT
Name: San
SELECT DB_NAME(dbid) as ’DatabaseName’, COUNT(dbid) as ’OpenConnections’ from master.dbo.sysprocesses with (nolock) WHERE dbid > 0 GROUP BY dbid