Home Forums Article Discussions Article Discussions by Author Discuss content posted by Abhijit Kill Active connections RE: Kill Active connections

  • December 23, 2009 at 2:34 am

    #1095832

    There is another option that you can use to kill all active connection the database and make database read only

    ALTER DATABASE <mydb> SET READ_ONLY WITH ROLLBACK IMMEDIATE

    Abhijit - http://abhijitmore.wordpress.com