Run this script after restoring database to another server. Set restored database as a current database in the Enterprose Manager before running script in the query window.
What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?
With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.