subscriber_id in MSSubscriptions table. Where is it defined?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » subscriber_id in MSSubscriptions table. Where...

subscriber_id in MSSubscriptions table. Where is it defined?

Rate Topic

Display Mode

Topic Options

Author

Message

BaldingLoopMan

Posted Wednesday, December 09, 2009 6:56 AM

Old 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

BaldingLoopMan

Posted Tuesday, December 15, 2009 12:07 PM

Old 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 »

Permissions