Chris Straw
SHARE:

SQL Server script to find and change schema ownership

SELECT *,
'ALTER AUTHORIZATION ON SCHEMA::' + QUOTENAME(SCHEMA_NAME) + ' TO db_owner;'
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_OWNER = 'OwnerUserHere'