sys.database_principals
seems to list the same users as sys.sysusers
. The following two queries return no record, at least on the Server and database I am currently working on: select name from sys.database_principals except select name from sys.sysusers; select name from sys.sysusers except select name from sys.database_principals;
select … from sys.database_principals where is_fixed_role = 1
.