Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: SQL Server Single User mode

    How can I install SQL Server in single user mode? I want this because I want only one user to work on the application.

    Thanks in advance

    Regards,
    Sushma

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Install the SQL server in normal mode and follow as specified in BOL:


    To start the default instance of SQL Server in single-user mode from a command prompt
    • From a command prompt, enter: sqlservr.exe -c -m


    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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