Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2008-03-13 : 09:30:33
|
| I wanna detach a database. Cleared all processes and stopped all app services. And when I tried to detach it, still got "can not detach the 'mydb', because the db currently in use."What I missed here? The db is in SQL 2000.How do I trace all connected users?Help please! |
|
|
DNF98
Starting Member
12 Posts |
Posted - 2008-03-13 : 09:32:26
|
| Run sp_who2 in Query Analyzer to view the connections |
 |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2008-03-13 : 09:58:56
|
| I ran it. Nothing show up from the result. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-13 : 23:21:31
|
| There is check box to disconnect users in datch db page. |
|
|
|
|
|
|
trace the connection on databases