Tuesday, September 27, 2011

How to fix Orphan users in Sqlserver

The orphan users can be fixed by executing sp_change_users_login procedure. The syntax would be

Syntax :
sp_change_users_login 'update_one', 'Username','UserName'