I have created several databases in an instance in SQLServer 2008. I want to change the dbowner to 'dbo' instead of myself. How do I do it? What command should I use to perform this change?
I have tried run this command: EXEC sp_changedbowner 'dbo' and I got the following error message:
Msg 15151, Level 16, State 1, Line 1
Cannot find the principal 'dbo', because it does not exist or you do not have permission.
Please help me out on this.