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)
 chaning the dbo name

Author  Topic 

rishysingh
Starting Member

4 Posts

Posted - 2005-07-26 : 17:57:55
i want the code to change the dbo name of the table in sql.

Th anks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-26 : 18:14:51
sp_changeobjectowner is the system stored procedure that can change the object's owner. See SQL Server Books Online for details on it.

Tara
Go to Top of Page
   

- Advertisement -