SQL Server Performance

Replicate Logins

Discussion in 'Performance Tuning for SQL Server Replication' started by photura, Jun 22, 2006.

  1. photura New Member

    Is it possible to replicate logins using transactional replication?

    Thanks.
    photura, Jun 22, 2006
    #2

  2. contactjimmys New Member

    Transactional replications replicate the transactions.If any changes happend to login that also will be reflected in it .


    Jr DBA
    SHAMS
    contactjimmys, Jun 23, 2006
    #2

  3. photura New Member

    I found out that system tables are not replicated. Which means if you add a new user to a database that new user will not get added to the subscribing database.

    What's the easiest way to ensure database users are synched?



    quote:Originally posted by photura

    Is it possible to replicate logins using transactional replication?

    Thanks.
    photura, Jun 26, 2006
    #2

Share This Page