<< Solution: It takes much longer to run a stored procedure than run the code inside the stored procedure | Change Database-Table Collations >>

Map existing SQL Server Login to an existing Database User

by Michael R. Albertin 24. June 2011 09:55

The following statement maps an existing SQL Server Login to an existing Database User

EXEC sp_change_users_login 'update_one', 'loginName', 'dbUserName'

Tags: user, login

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2012 Syntax Error