SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE NAME='promoter' )

select * from sysprocesses where dbid in (select dbid from sysdatabases where name='promoter')

SP_WHO 'sa'