Biz(Talk)2

Talk, talk and more talk about BizTalk

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.

April 28, 2009 - Posted by Brett | Uncategorized | | No Comments Yet

No comments yet.

Leave a comment