sp_changeobjectowner - running gives object does not exist
Posted on 2007-07-25
In SQL Server 2005 I have a database diagram named 'diagRel' and it's owner is 'DOM\Forename.Surname'.
I want to change the owner to dbo (i have full persmission on the db) but when I run:
EXEC sp_changeobjectowner 'DOM\Forename.Surname.diagRel', 'dbo';
I get the error:
Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 62
Object 'DOM\Forename.Surname.diagRel' does not exist or is not a valid object for this operation.
I've tried it like this too:
EXEC sp_changeobjectowner '[DOM\Forename.Surname].diagRel', 'dbo';
with the same results.