![]() |
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
DBNest.com (Nest of DB Professionals)
![]() |
How to change the owner of all tables in a database? |
|
|
DECLARE @oldowner sysname, @newowner sysname, @sql varchar(1000) SELECT EXECUTE sp_MSforeachtable @sql |
|