Wednesday, February 1, 2012

which owner owns which schema

SELECT
FROM
s.name,p.name sys.schemas s inner join sys.database_principals p on s.principal_id = USER_ID(p.name)

No comments:

Post a Comment