Add the new login. USE master go EXEC sp_addlogin 'NewMary' go --Change the user account to link with the 'NewMary' login. USE pubs go EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary' EXEC sp_change_users_login 'Update_One', 'ESPDAUser', 'ESPDAUser'