November 22, 2007 at 2:56 am
hi
i am going to apply log shipping on my live database server
for that purpose i have done stand by server and install sql server 2000
take a backup from production and restored to stand by server
Problem:
I am unable to use database/NT user on stand by server
i just wana script to migrate DB/NT users from production to stand by server.
Your help will highly be appriciated.
Regards
Syed Naveed
November 26, 2007 at 2:51 am
If you want to script out users from production database to your stand by database hope this script of mine can help you. Just run this script to your production database then copy the result and execute in your standby database... Please read the comments carefully thanks!!!!!
"-=Still Learning=-"
Lester Policarpio
November 26, 2007 at 5:17 am
thank you so much my dear its really great script
i havn't words for you
Best take care of your self
Regards
Syed Muhammad Naveed
November 26, 2007 at 5:21 pm
Thanks for the compliment 🙂
"-=Still Learning=-"
Lester Policarpio
November 27, 2007 at 9:26 am
Although I see nothing wrong with the script, there is a perferred method.
So I suggest that you use the method recommended by MS which is to use the sp_help_revlogin procedure.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply