Home Forums Article Discussions Article Discussions by Author Discuss content posted by Abhijit Kill Active connections RE: Kill Active connections
Jason Carlson
Grasshopper
Points: 21
More actions
October 21, 2009 at 3:47 pm
#1069162
I agree, I think the ALTER DATABASE <databaseName> SET SINGLE_USER WITH ROLLBACK IMMEDIATE is more elegant and precludes the risk of active connections occurring while the cursor is killing the ones it knew about at the time the cursor was opened.