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'