Automatically mapping a user to a login in SQL Server

Automatically mapping a user to a login, creating a new login if it is required

The following example shows how to use Auto_Fix to map an existing user to a login of the same name, or to create the SQL Server login Mary that has the password B3r12-3x$098f6 if the login
Mary does not exist.

EXEC sp_change_users_login 'Auto_Fix', 'Mary', NULL;
GO

for more info, go to msdn website at:

http://msdn.microsoft.com/en-us/library/ms174378.aspx