How to change the owner of all tables in a database? |
|
|
DECLARE @oldowner sysname, @newowner sysname, @sql varchar(1000) SELECT EXECUTE sp_MSforeachtable @sql |
|
Powered by
KBPublisher (Knowledge base software)
How to change the owner of all tables in a database? |
|
|
DECLARE @oldowner sysname, @newowner sysname, @sql varchar(1000) SELECT EXECUTE sp_MSforeachtable @sql |
|