Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Rahul Sharma Drop all Connections from a Database RE: Drop all Connections from a Database
noelpv
SSC Journeyman
Points: 92
More actions
June 12, 2008 at 12:38 pm
#828057
I use this:
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE