Technology Wavering

Monday, February 24, 2014

SQL commands

Remove database single user mode
exec sp_dboption 'testdb01', 'single user', 'FALSE'

Set database to single user mode
ALTER DATABASE dbName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE


Posted by Jayanthi Krishnamurthy at 11:50 AM

1 comment:

Anonymous said...

test

December 4, 2016 at 8:09 PM

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Jayanthi Krishnamurthy
View my complete profile

Search This Blog

Blog Archive

  • ►  2020 (1)
    • ►  March (1)
  • ►  2015 (1)
    • ►  August (1)
  • ▼  2014 (1)
    • ▼  February (1)
      • SQL commands
  • ►  2012 (4)
    • ►  December (1)
    • ►  August (3)
  • ►  2011 (1)
    • ►  August (1)
  • ►  2010 (10)
    • ►  December (1)
    • ►  March (3)
    • ►  February (3)
    • ►  January (3)
  • ►  2009 (19)
    • ►  October (2)
    • ►  August (1)
    • ►  July (1)
    • ►  June (6)
    • ►  May (4)
    • ►  April (5)
  • ►  2008 (8)
    • ►  December (5)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
Simple theme. Powered by Blogger.