You can use sp_who or sp_who2 active to identify the spids to the various
databases.To remove them, you need to KILL the spids manually or write some
scripts which queries sysprocesses table.
SQL Server FAQ at
"CyberSpider" <com> wrote in message