/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
-- Showing a report of the current user to login mappings EXEC sp_change_users_login 'Report'; GO -- Automatically mapping a user to a login, creating a new login if it is required EXEC sp_change_users_login 'Auto_Fix', 'Mary', NULL, 'B3r12-3x$098f6'; GO
URL: http://msdn.microsoft.com/en-us/library/ms174378.aspx