I am running SQL2000 on a Windows 2003 server. I am trying to migrate the databases to a newer server. I have one database I have moved and to verify everything is correct and I have nothing pointing to it I want to take it offline. Every time I try I receive the following message
Error 5070: Database state cannot be changed while other users are using the database.
I executed SP_WHO2 and there are 4 connections to the database with a status of Background and a command of TASK MANAGER
If in SQL Server Enterprise Manager I go to Management-Current Activity and look in Locks/Object I see the 4 Process IDs. If I look at the properties the Last TSQL command batch is empty and if I select Kill Process nothing happens. If I refresh or exit and get back in it is still there. I have the same results if I try it from Locks /Process ID.
I have looked in scheduled tasks, Under SQL Server Agent and I can not find anything which should be accessing the database
How do I identify what is using the database and cancel it so I take it offline?