[ISSForum] How to move the realsecuredb to other partition

[issforum-admin]

Dear All,   I am using Site Protector 2.0 with MS SQL 2000 SP3, and I want to move the RealSecureDB.MDF and RealSecureDB_log.LDF to the other partition, and I have try the following command by Query Anayiz:   Stop the issDaemon, and then   1) use RealSecureDB 2) go 3) exec sp_detach_db RealSecureDB 4) go 5) Error: Server: Msg 3701, Level 16, State 3, Line 1     Cannot detach the database 'RealSecureDB' because it is currently in use.   Second Mehtod:   I try is by Enterprise Manager, and then right click the DB 'RealSecureDB' > choose 'All Task' >  choose 'Detach Database' > and then I will see a prompt up screen with the following information:   Connections using this database: 5   Therefore I can not click OK.   Please tell me how to stop all connection from the service which will use this database.   Thanks   Best Regards,   Tony Wu