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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy