Fix broken username after database attach - SQL Snipplr Social Repository

Revision: 29927

at July 20, 2012 05:39 by lance

Updated Code

EXEC sp_change_users_login 'auto_fix','UserName'
EXEC sp_change_users_login @action = 'auto_fix', @UserName = '<user>', @Password = '<pass>'

Revision: 29926

at August 5, 2010 05:52 by lance

Initial Code

EXEC sp_change_users_login 'auto_fix','UserName'

Initial URL

Initial Description

Sometimes the first set of parameters don't work so then use the second

Initial Title

Fix broken username after database attach

Initial Tags

Initial Language

SQL