Home > IT Answers > SQL Server > Drop Database Connections
Javad
5 pts.
 Drop Database Connections
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server databases, T-SQL
Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)

Software/Hardware used:
ASKED: April 11, 2009  8:12 AM
UPDATED: April 13, 2009  1:53 PM
RELATED QUESTIONS
Answer Wiki:
Hi I guess that this should do it: <b>ALTER DATABASE DATABASE_NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE</b>
Last Wiki Answer Submitted:  April 11, 2009  8:30 am  by  alessandro.panzetta   9,680 pts.
All Answer Wiki Contributors:  alessandro.panzetta   9,680 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _