Changing table owner

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_changeobjectowner [ @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

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?

Hi

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

sp_changeobjectowner '[dnnadmin].[aspsearch]' , 'dbo'

John