Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

subscriber_id in MSSubscriptions table. Where is it defined? Expand / Collapse
Author
Message
Posted Wednesday, December 09, 2009 6:56 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 05, 2012 7:23 AM
Points: 304, Visits: 457
Looking in the MSsubscriptions system table i notice there is a subscriber_id. Where is this id coming from? Is there a table who holds a distinct list of the subscriber's? If so i can't find it. If it doesn't exist can someone please in the simplest terms explain why?



CREATE TABLE [dbo].[MSsubscriptions](
[publisher_database_id] [int] NOT NULL,
[publisher_id] [smallint] NOT NULL,
[publisher_db] [sysname] NOT NULL,
[publication_id] [int] NOT NULL,
[article_id] [int] NOT NULL,
[subscriber_id] [smallint] NOT NULL,
[subscriber_db] [sysname] NOT NULL,
[subscription_type] [int] NOT NULL,
[sync_type] [tinyint] NOT NULL,
[status] [tinyint] NOT NULL,
[subscription_seqno] [varbinary](16) NOT NULL,
[snapshot_seqno_flag] [bit] NOT NULL,
[independent_agent] [bit] NOT NULL,
[subscription_time] [datetime] NOT NULL,
[loopback_detection] [bit] NOT NULL,
[agent_id] [int] NOT NULL,
[update_mode] [tinyint] NOT NULL,
[publisher_seqno] [varbinary](16) NOT NULL,
[ss_cplt_seqno] [varbinary](16) NOT NULL,
[nosync_type] [tinyint] NOT NULL
) ON [PRIMARY]


Post #831364
Posted Tuesday, December 15, 2009 12:07 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 05, 2012 7:23 AM
Points: 304, Visits: 457
i found where it is being defined.

it appears the subscriber_id is coming from the srvid in the master.dbo.sysservers table
Post #834694
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse