This stored proc is going to be deprecated in new versions of SQL Server. So how do we map a user, we can use the
ALTER USER
function.For Example:
EXEC sp_change_users_login 'Auto_Fix', 'username', NULL, 'password';
now becomes
ALTER USER [username] WITH LOGIN = [username], PASSWORD = 'password';
No comments:
Post a Comment