Monthly Archives: June 2014

How to set database as Single User TIP #10

Sometimes it is require to  set database as single user for maintenance or other recovery purpose. We need to write following statement GO ALTER DATABASE FriendsDBSET SINGLE_USER  WITH  ROLLBACK IMMEDIATE; GO Here ROLLBACK IMMEDIATE  means if any transaction going on by other user then Rollback that data. See below snap for more detail Enjoy !!!