Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Smile Unanswered: single user mode

    hello,

    Is there any way of setting the database option to "single user" with the help of a SQL query?

    Thanx,

  2. #2
    Join Date
    Feb 2003
    Location
    Waalwijk, the Netherlands
    Posts
    23
    hi,
    use master
    go
    sp_dboption dbname 'single', true
    go
    checkpoint
    go

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •