January 13, 2003 at 2:59 pm
The old DBA has left the company and I have I have found Several databases that have his Domain Account listed as owner of the database. His account has been removed from security on the server. When I try and run the "sp_changedbowner" to change the owner to 'sa' I get the following message:"Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 48
The proposed new database owner is already a user in the database." How can I make 'sa' the new owner of these databases.
January 13, 2003 at 7:07 pm
Try Changing the owner of the database to probably your login id or any other login id and then change to sa. Hope this helps.
January 14, 2003 at 8:41 am
Try also deattaching you db , and then attaching it again. There, through EM you can specify a new db owner
January 14, 2003 at 2:17 pm
I ran into a similar problem and I just changedbowner to the original window NT login owner. Once the ownership had taken place, I were able to change it to the 'sa' as the db owner. Hope this fix your problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply