Advanced Search

Errors and Resolutions

/ Published in: SQL
Save to your folder(s)
Errors and Resolutions

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.