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)
 Change Owner

Author  Topic 

sp_wiz
Yak Posting Veteran

55 Posts

Posted - 2001-07-23 : 08:22:13
Is it possible to change the ownership of a table.

I have a new server but some of the tables where created with an owner that does not exist now.

Is it possible to change the ownership to dbo. with out having to drop the tables and loose all the data.

Robp


   

- Advertisement -