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'
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
SQL Server BLOG for information about Sql server all versions for viewers working on SQL Server Database.
No comments:
Post a Comment