How do you kill all current connections to a SQL Server 2005 database?
- by Adam
I want to rename a database, but keep getting the error that 'couldnt get exclusive lock' on the database, which implies there is some connection(s) still active.
How can I kill all the connections to the database so that I can rename it?