top of page
  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon
Search

How to Change All User Databases to Multi User Mode?

  • Writer: Filip Holub
    Filip Holub
  • Feb 1, 2017
  • 1 min read

If you want to switch all databases to multi 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:

Multi user mode for all databases

See you next time!

 
 
 

Comentários


RECENT POST
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

bottom of page