Adding a Sql user that already exists
Occasionally I’ll need to copy a database over to my dev machine in order to be able to work offline.
USE <Target_Database> EXEC sp_change_users_login 'Update_One', '<Server_User>', '<Database_User>'
This will re-associate the Server Login with the specified Database Login.
No comments yet.
Leave a comment
-
Archives
- November 2009 (1)
- September 2009 (1)
- August 2009 (2)
- July 2009 (2)
- June 2009 (1)
- April 2009 (2)
- March 2009 (2)
- February 2009 (1)
- January 2009 (1)
- September 2008 (3)
- August 2008 (4)
-
Categories
-
RSS
Entries RSS
Comments RSS


