MS SQL Server 2008 R2
To fix user login from the restored full db run the query below
EXEC sp_change_users_login 'Auto_Fix','user1',NULL,'mypassword'
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Compilation of technology information, technical problems encountered and their solutions.
Followers
Web Developer
- Jesse Patricio
- Microsoft Certified Professional Microsoft Technology Specialist (SQL Server 2005 and Net 2.0 Framework)
No comments:
Post a Comment