Change owner schema for all database tables

Had this issue when restoring an Umbraco database created under a different user. This will alter the schema owner on all tables of the target database.

exec sp_MSforeachtable "ALTER SCHEMA TargetSchema TRANSFER ?"



No Comments


You can leave the first : )



Leave a Reply

Your email address will not be published. Required fields are marked *