SQL modification table owner
Wednesday on February 4th, 2009Life
A single modify owner sql statement is as follows:
Query analyzer input: EXEC sp_changeobjecowner 'user.table','dbo'
user.table means: owner. Table name. The statement means to change the owner of the table from user to dbo
. The statement is as follows:
Query analyzer input: exec sp_msforeachtable 'sp_changeobjecowner''? ', 'dbo'' can
change all owners of the current table to dbo
Copyright Protection: ShuDudu from the original article, reproduced Please keep the link: https://www.shududu.com/life/SQL-modification-table-owner.htm
