advanced code snippet search

Posted By

hairajeshk on 01/24/11


Tagged


Versions (?)

Errors and Resolutions

 / Published in: SQL
 

Errors and Resolutions

Expand | Embed | Plain Text 
  1. CHANGE FROM restriction mode TO multiuser
  2. IF we are getting an error "Property owner is not available for database"
  3.  
  4. USE DatabaseName
  5. go
  6. sp_changedbowner 'sa'
  7. go
  8.  
  9. ALTER DATABASE database-name SET MULTI_USER

Report this snippet  

You need to login to post a comment.