sp_changeobjectowner error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

sp_changeobjectowner error

Author

Topic

rb1373
Yak Posting Veteran

93 Posts

Posted - 2005-04-27 : 18:55:12

When I run this command,

sp_changeobjectowner 'OtherTable', 'dbo'

I recieve this error:

Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 38
Object 'OtherTable'does not exist or is not a valid object for this operation.

What is causing this error?

(I have admin privileges when I execute the command.)

Thanks,
Ray
SS2K SP3

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-04-27 : 19:15:47

You need to include the current owner name as part of the object:

sp_changeobjectowner 'NonDbo.OtherTable', 'dbo'

rb1373
Yak Posting Veteran

93 Posts

Posted - 2005-04-28 : 11:36:00

Awesome! That was it! Thanks again!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources