change owner of table

[zhonghandle]

Hi

How can I change the owner of tables from "owner" to "dbo" using a script or stored procedure? If I have 60 tables, it is inpractical to change them manually, so is there a way to change it all together?
Thanks in advance.

 

[tlbroadbent]

Yo can use the system stored procedure sp_changeobjectowner. Create a SQL script to generate the SQL statements that change the owners.

Select
'Exec sp_changeobjectowner ''oldowner.[' +
name + ']'',''dbo'''
From sysobjects
Where type='u'
And uid=user_id('Oldowner')

Copy the results from the results window and paste into a new query window. Then Execute the new script. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.