| chrisb 2002-12-20, 11:23 pm |
|
from BOL:
This example changes the owner of the authors table to
Corporate\GeorgeW.
EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW'
ChrisB
MCDBA MCSE
www.MyDBA2000.com
>-----Original Message-----
>
>Hello All,
> I need to change the owner of particular table
>to another owner. How can i change it?
>
>For example there are two owners 1. dbo and 2. bapu for
>SQL S erver database. In that database some of the tables
>created by owner dbo and some of tables by owner bapu. I
>need to maintain the single owner for all tables. how can
>I change the owner name...can you please help me to solve
>this problem.
>
>Thanks,
>BAPU
>.
>
|