SELECT s.name FROM sys.schemas s WHERE s.principal_id = USER_ID('YourUserID'); ALTER AUTHORIZATION ON SCHEMA::YourSchemaName TO dbo;