Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Reattach SQL server database user to SQL server login (SQL)
Title: Reattach SQL server database user to SQL server login Language: SQL
Description: Reattaches a database user to an existing SQL server login. This is useful after a database restore from a backup when the logins are detached from the users. See more information: http://technet.microsoft.com/en-us/library/ms174378.aspx Views: 847
Author: Ben Ramey Date Added: 2/25/2010
Copy Code   
USE <DATABASE_NAME>;
GO
EXEC sp_change_users_login 'Update_One', '<USERNAME>', '<SQLSERVERLOGIN>';
GO