Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71

    Unanswered: Replicating SysTables

    Good Day Gurus

    I posted a question about replicating logins to the database and the answer i got about doing a DTS to transfer logins is not good for me, is it possible to replicate syslogins tables so that i can do this if so, how because they are not listed Database and Publications when i try to create a publication, only individual created databases can be seen.

    The reason for this is because when the DBA decides to change the user permission, i want the info to be merge replicated to the subscriber. At this moment i can run the DTS to transfer the login but it won't know when the logins have been updated and hence i won't know when to run it.

    Thanks in advance

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

  3. #3
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71
    Satya, the store proc is great but it doesn't fix my problem, instead of running copying the results and run them at subsriber manually. I want the replication to do this for me and for now it seems impossible because this store proc is created at master level not at DB level so you can't actually see this store proc to replicate. If you can tell me that it is possible to create it at DB level, that will work great

Posting Permissions

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