title: SQL 2000 single mode, related to database dbcc checkdb
body: <p>I am trying to hack opening a MDF file in a new database. We lost the backup.</p>
  
  <p>After reading numerous articles, I came to the point where the only thing that separates me from a successful solution is setting the db into a single user mode.</p>
  
  <p>I issue "sp_dboption 'MyDbName',single,true"
  SQL Server reports that "The command(s) completed successfully."</p>
  
  <p>Then I run "DBCC CHECKDB ('MyDbName',REPAIR_ALLOW_DATA_LOSS)"</p>
  
  <p>and it complains that "Repair statement not processed. Database needs to be in single user mode."</p>
  
  <p>This is frustrating to no end. It's like an intentional convoluted torture by MSFT developers.</p>
  
  <p>I am not a DB admin, I am a programmer that needs to make this database restored, at least the stored procedures that we lost. </p>
  
  <p>Thanks for your help!</p>