HI robert & perry

ya ivl follow the link and script also if needed. Before that i want to know one thing where should i execute this script for mapping the logins after

SWITCH OVER COMPLETE whether in primary server or in secondary server

-----------------------------------------------------

EXEC sp_change_users_login'report'

and

Exec sp_change_users_login'auto_fix',users

------------------------------------------------------

Actually when we perform dc dr dill[switch back & switch over ] it wont be much time for DBA to carry this activity and if i follow this script there is difficult to remmeber long script instead i want to go through the simple script which i provided above just need calification when and where to execute

special thanks to u both