• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

How to Change All User Databases to Single User Mode?

January 30, 2017

If you want to switch all databases to single user mode, you can use my cursor script below:

 

 This Script change all databases of instance which are in a state MULTI_USER mode, except system databases (Master, Model, MSDB and TempDB). However, there can be problem with open connection on database, in this case ALTER database failed! Therefore use my script for kill all  open connection on database - HERE!

 

The result should look like this:

 

 

See you soon!

 

Please reload

RECENT POST
Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon