How can I change a table/view owner?

Hi,
We have a database in which we would like to change the owner of certain
tables and views. Can someone help me to do this? If there is a script
that I can use then that would be perfect. Thanks in advance.
With best regards,
Parimal
Email: Parimal.Jani@.hp.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!sp_changeobjectowner
"PARIMAL JANI" wrote:

> Hi,
> We have a database in which we would like to change the owner of certain
> tables and views. Can someone help me to do this? If there is a script
> that I can use then that would be perfect. Thanks in advance.
> With best regards,
> Parimal
> Email: Parimal.Jani@.hp.com
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>