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'... ?

[Back to original message]