• Got a Tipila, google, windows live or facebook account ?

Following will create the login tom with password 0101 if it does not exist or associate the use with an existing login with the same name

USE mydatabase;
GO
EXEC sp_change_users_login 'Auto_Fix', 'tom', NULL, '0101';
GO

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

1
votes
Login to Tipila