Posted by BD on 12/28/06 03:09

> USE MyDatabase
> EXEC sp_changedbowner 'sa'
>
> --
> Hope this helps.


Thanks, Dan - I expect it will.

Out of curiosity, though - I presume that dbo is unique in this regard
- ie., if the same thing had happened with a different ID, I'd have to
reassociate it 'the hard way'... ?

• Next in forum: Re: server version
• Prev in forum: Re: Question: re-associate dbo with sa??
• Thread view: Re: Question: re-associate dbo with sa??

[Reply to this message]