Skellywag

Wednesday, January 25, 2006

Reconnecting orphaned users in SQL server

EXEC sp_change_users_login 'Auto_Fix', '<username>', NULL, '<userpassword>'

[Microsoft][ODBC SQL Server Driver][SQL Server]The row for user 'jimbo' will be fixed by updating its login link to a login already in existence. [Microsoft][ODBC SQL Server Driver][SQL Server]The number of orphaned users fixed by updating users was 1. [Microsoft][ODBC SQL Server Driver][SQL Server]The number of orphaned users fixed by adding new logins and then updating users was 0.

From SQL Server Books Online


0 Comments:

Post a Comment

<< Home