SQL SERVER – 2005 – Retrieve Processes Using Specified Database | Journey to SQL Authority with Pinal Dave

Blog Reader Jim Sz posted quick but very interesting script. If user want to know how many processes are there in any particular database it can be retrieved querying sys.processes database. USE master GO DECLARE @dbid INT SELECT @dbid = dbid FROM sys.sysdatabases WHERE name = 'AdventureWorks' IF EXISTS (SELECT spid FROM sys.sysprocesses WHERE dbid… Continue Reading...

Source: SQL SERVER – 2005 – Retrieve Processes Using Specified Database | Journey to SQL Authority with Pinal Dave