December 8, 2009 at 3:10 pm
Looking in the below 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]
December 8, 2009 at 3:12 pm
i see there is a MSsubscriber_info table however it doesn't have an id column which i find very bizarre.
CREATE TABLE [dbo].[MSsubscriber_info](
[publisher] [sysname] NOT NULL,
[subscriber] [sysname] NOT NULL,
[type] [tinyint] NOT NULL,
[login] [sysname] NULL,
[password] [nvarchar](524) NULL,
[description] [nvarchar](510) NULL,
[security_mode] [int] NOT NULL
) ON [PRIMARY]
December 8, 2009 at 3:14 pm
i ran the following to find where this subscriber_id originates and can't find it.
select distinct tb.table_name
from INFORMATION_SCHEMA.TABLES tb (nolock)
join INFORMATION_SCHEMA.COLUMNS col (nolock)
on tb.table_name = col.table_name
where table_type = 'base table'
and COLUMN_NAME like '%sub%'
December 8, 2009 at 3:38 pm
Dont everyone answer at once now.
November 22, 2011 at 8:40 am
Better late than never! subscriber_id can be joined to master.dbo.sysservers. NOTE: Not master.sys.servers. It has something to do with different ways servers can be related, replication, linked, etc. Anyway, I was trying to find out what an ID of -1 means. Let me know if you know.
November 21, 2024 at 12:57 am
Hi,
On my server, srvid from master.dbo.sysservers is definitely NOT the source for distribution.dbo.MSsubscriber_info.subscriber_id.
Sincerely,
Daniel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply