Verifica Schema

Esse script retorna a consulta dos schemas da base de dados. As colunas devem ser iguais sempre.

SELECT s.name,
       p.name
FROM   sys.schemas s INNER JOIN sys.database_principals p
       ON	(s.principal_id = p.principal_id)

/*
ALTER AUTHORIZATION ON SCHEMA::db_owner TO db_owner;
ALTER AUTHORIZATION ON SCHEMA::db_datareader TO db_datareader;
ALTER AUTHORIZATION ON SCHEMA::db_datawriter TO db_datawriter;
*/

select object_name(object_id), execute_as_principal_id, user_name(execute_as_principal_id)
from sys.sql_modules
where execute_as_principal_id is not null
order by 1