Orphaned SQL Server Users

The Scenario: You’re working on a SQL database locally and when you restore the database on the  production server the login no longer works.  The user has been orphaned. Solution #1 – Delete and recreate the user from scratch Solution…