Post reply

UID in SYSUSERS change During DTS

  • June 6, 2006 at 12:27 pm

    #168675

    I have a database which I store data on users in a user table. This table links to the sysusers table by storing the UID value in my user table.  The problem is whenever we use DTS to create a new database (for testing, Etc) the UID values in sysusers change and no longer match my user table. 

    Any ideas to keep the UID the same?

    Thanks.

    fryere

  • June 6, 2006 at 12:43 pm

    #642119

     

    1. For SQL Logins: on the test /development servers create logins that have the same SIDs as on the production. Use SID instead of UID for your user table.

    OR

    2. When moving the database run a script that will replace UID in your user table based on the user name and UID in sysusers

    Regards,Yelena Varsha

  • June 7, 2006 at 10:56 am

    #642345

    Just curious as to why you are not storing name instead ? It would seem that this method would lend itself to fewer issues.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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