SQL_Users_orphaned.sql

/* Run against the restored database */

SET NOCOUNT ON;

-- Check for database users without parent logins on the server
SELECT  name, type_desc, create_date, modify_date, sid
FROM    sys.database_principals
WHERE   type IN ( 'U', 'G', 'S' ) AND
        name NOT IN ( 'dbo', 'guest', 'INFORMATION_SCHEMA', 'sys' ) AND
        name NOT IN ( SELECT    name
                      FROM      sys.server_principals );