Sql Server - How do I change the user mode?

• jruiseco

  SSC Enthusiast

  Points: 162

  More actions

  October 14, 2002 at 11:13 am

  #58127

  I just applied service pack 2 to my Sql Server 2000 and now am in single user mode. How do I change back to multi-user mode?

• hirenk

  SSCrazy

  Points: 2000

  More actions

  October 14, 2002 at 11:51 am

  #438520

  run this.

  sp_dboption 'DB_name', 'single user', 'False'

  you will get confirmaion that DB is now in multi user mode.