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 *