October 6, 2003 at 6:28 pm
Receiving error 21776:The name 'dbo' was not found in the users collection.
In short, dbo exists on some databases but not listed in master (don't know what happened). Whats good way to fix??
Thanks.
October 6, 2003 at 6:38 pm
There are several Knowledge Base articles related to this issue. Hopefully one of these is a fit:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q305711
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q218172
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Basically, use sp_changedbowner to set the database owner to sa.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
October 7, 2003 at 8:54 am
Thanks Brian, of course you had the correct answer and it worked! It was getting late last night and ....
quote:
There are several Knowledge Base articles related to this issue. Hopefully one of these is a fit:http://support.microsoft.com/default.aspx?scid=kb;EN-US;q305711
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q218172
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Basically, use sp_changedbowner to set the database owner to sa.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply