I want to know:
1) is there is some unique ID for a subscription to a publication (in SQL Replication)?
2) Can this ID be accessed on the subscriber and publisher databases?
3) Is there view/table/store procedure that will give me a list of subscribers at the publisher (that will also expose this unique ID.
This information will be very helpful for partitioning data in our enterprise system that we are developing.
I.e.: A remote site (subscriber) may have read/write access to its allocated data-partition, but only read-access to other data-partitions (obviously only if the particular user has permission to read the data in the partition). The main site (publisher) will
allocate each data partition to a subscriber.
This 'unique ID' will help us allocating a data-partition to a subscriber.
I see that the stored procedure sp_helppullsubscription returns a 'subscription guid' column, but MSDN describes the column as 'Global identifier for the version of the subscription on the publication.', so I'm not sure (due to the word 'version' in the sentence)
if this GUID will change each time the subscription is resynchronized (or for any other unknown reason)? Also, I cannot find an object that will return a list of subscribers (that include this 'subscription guid') on the published database.
-
-
I got help from this site:
http://sadeveloper.net/forums/thread/17210.aspx
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.