Changing table owner

[Manning]

Hi- apologies for asking a stupid newbie question, but I'm really stuck at
the moment. I need to change table ownership.

I've got an asp script which is looking for a table owned by the dbo role,
however the table was created under a different ownership. I understand the
problem, and almost understand the solution, but I can't seem to get all the
way.

THE PROBLEM (using [server].[database].[owner].[table])
[mgbsvr1].[dnn].[dnnadmin].[aspsearch]
needs to be
[mgbsvr1].[dnn].[dbo].[aspsearch]

I looked up the books online and found this syntax:
sp_changeobject owner [ @objname = ] 'object' , [ @newowner = ] 'owner'

But I can't see how to use it, nor more importantly, where I should use it.
It won't work in the query tool in Enterprise Manager. If I need to create a
script (which I've never done before), how do I execute the script?

All help deeply appreciated
Manning, Sydney

[John Bell]

Hi

You will need to be connected to [mgbsvr1].[dnn] with either sysadmin,
db_ddladmin and db_securityadmi n rights or the dbo to issue the statement

sp_changeobject owner '[dnnadmin].[aspsearch]' , 'dbo'

John

"Manning" <ma*****@NOSPAM bartlett.net> wrote in message
news:bl******** **@lust.ihug.co .nz...

Hi- apologies for asking a stupid newbie question, but I'm really stuck at
the moment. I need to change table ownership.

I've got an asp script which is looking for a table owned by the dbo role,
however the table was created under a different ownership. I understand the problem, and almost understand the solution, but I can't seem to get all the way.

THE PROBLEM (using [server].[database].[owner].[table])
[mgbsvr1].[dnn].[dnnadmin].[aspsearch]
needs to be
[mgbsvr1].[dnn].[dbo].[aspsearch]

I looked up the books online and found this syntax:
sp_changeobject owner [ @objname = ] 'object' , [ @newowner = ] 'owner'

But I can't see how to use it, nor more importantly, where I should use it. It won't work in the query tool in Enterprise Manager. If I need to create a script (which I've never done before), how do I execute the script?

All help deeply appreciated
Manning, Sydney

[Erland Sommarskog]

Manning (ma*****@NOSPAM bartlett.net) writes:

But I can't see how to use it, nor more importantly, where I should use
it. It won't work in the query tool in Enterprise Manager. If I need to
create a script (which I've never done before), how do I execute the
script?

Enterprise Manager is not much of a query tool. Use Query Analyzer
instead.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Manning]

John and Erland

Thanks for your advice - problem fixed.

Manning

"John Bell" <jb************ @hotmail.com> wrote in message
news:3f******** **************@ reading.news.pi pex.net...

Hi

You will need to be connected to [mgbsvr1].[dnn] with either sysadmin,
db_ddladmin and db_securityadmi n rights or the dbo to issue the statement

sp_changeobject owner '[dnnadmin].[aspsearch]' , 'dbo'

John