How to close all connections of a database

A

ad

I use sp_detach_db to detach a database, but it fail when threre are some
connections to the database.
How can I close all connections of this database before I detach it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Connections 2
Detach SQL-Server Database from .NET 1
Detach sql files on closing? 1
detach database forcefully 1
How to make a backup from vb.net 2
SQL Server Express - Detach & Shrink 8
Detach database from SQL Server 4
SQL Questions: Attaching Databases to SQL Server 4

Top