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'
Tuesday, September 27, 2011
Subscribe to:
Posts (Atom)
SQL Server BLOG for information about Sql server all versions for viewers working on SQL Server Database.