Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: srussellpatriottran
- Order by date
-
Error 21776: [SQL-DMO] The name 'dbo' was not found in the users....
I had the same error. I created 2 new databases and neither had user dbo. My solution: 1. Script out all users for both DB. 2. Delete all users from both DB. 3. Run exec sp_changedbowner 'sa' for both DB. 4. Refresh to verify both DB to verify dbo user exists. 5. Run script to create...- srussellpatriottran
- Post #17
- Forum: Microsoft SQL Server: Setup and Administration
