I have found quite a bit about chaning object owners in SQL, however, I'm not having any luck with it. I'm REALLY NEW to SQL. Could someone tell me what I'm doing wrong?
exec sp_changeobjectowner 'elliott', 'dbo'
Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 38
Object 'elliott' does not exist or is not a valid object for this operation.
Elliott IS still the owner of these tables. HELP!!!