IT Solutions
Search This Blog
Saturday, July 10, 2010
How to update login of a database?
To update login information of a database use following sql statement:
sp_change_users_login 'Update_One', 'UserNamePatn', 'csurvey'
where 'Update_One' is action,UserNamePatn is user's name pattern and csurvey is login name
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment