Search This Blog

Tuesday, March 30, 2010

How to find Multiple connections to various databases on your SQL Server

SELECT distinct b.name
FROM master.dbo.sysprocesses a, master.dbo.sysdatabases b
WHERE b.dbid = a.dbid
AND a.uid = USER_ID(USER)

No comments:

Post a Comment