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 advanceHow about using information in this link [http://www.databasejournal.com/features/mssql/article.php/2228611] and KBA [http://support.microsoft.com/default.aspx?scid=kb;en-us;246133].
HTH|||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
No comments:
Post a Comment