Post reply

Export login script

  • December 12, 2007 at 1:14 pm

    #70530

    has anyone seen a good script to export logins for sql 2000 (nt sql auth). I need to do this for a log ship server. You can't use the dts package to do this, your db's on the log ship to server are read only. I just need the logins themselves to keep themselves in synch

  • December 13, 2007 at 11:40 pm

    #760090

    Here you go sir.... Run this script on your source database and then copy the result of this script and run in the destination database. I did not include the BUILTIN,sa and administrator log-ins. Just message me if there are other problems...

    "-=Still Learning=-"

    Lester Policarpio

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply