Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

sp_change_users_login

when i run
EXEC sp_change_users_login 'Report'
i get one row output..

but when i run the next line of code, it does fix it..
EXEC sp_change_users_login 'Auto_Fix', 'user'

any thoughts on how to go about seeing what the problem is.

thanks
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anushahanna

ASKER

if the second sp did not make it ok, what could be done next?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
so what would you do in this case? drop the users/login and create again?

i have a backup before this was restored? can i restore it on the same server to get the right user/login info?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
what is 'Update_One'?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

that worked.. thanks.