Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    167

    Unanswered: migrating logins (from one server to the other)...

    Do I need to sysc / bcp other system tables outside of syslogins? For example...

    Sync. the following system tables...

    - syslogins
    - sysloginroles
    - syssrvroles (which currently seems to be the same across all servers)
    - sysattributes (which currently seems to be the same accross all servers with both the object_type of 'UR' and 'PS').

    What are your thoughts?

    Thank you.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    sounds good to me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •