-
Cannot detach db
I am trying to detach an SQL7 db and reattach it to an SQL2K server. When I run sp_who I get a list of 10-15 processes that are running, most under my sa login. If I kill all the others and then try to run sp_detach_db I get the following:
Server: Msg 3702, Level 16, State 1, Line 0
Cannot drop the database 'snb01' because it is currently in use.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I have detached and reattached before, but I don't recall what I did differently. Pls help. TIA D. Lewis
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|