anushahanna
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
i have a backup before this was restored? can i restore it on the same server to get the right user/login info?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
what is 'Update_One'?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that worked.. thanks.
ASKER