Filtered Transactional Replication - Missing Rows

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm running SQL 2005 SP1 and have setup transactional replication to 3
subscribers. The publisher is it's own distributor. I have several tables
that are filtered and I keep getting a rows missing error on these tables. I
have rebuilt replication several times but I keep ending up with the same
problem. So I have 2 questions:

1) I can see the commands using sp_browserreplcmds @article_id: How can I
determine which commands to rerun and how can I apply them at the
subscribers?

2) How can I determine what is causing the problem. Following are the schema
and article filter for the article currently experiencing the problem:

SCHEMA:

CREATE TABLE [dbo].[table_athlete](
[ID] [uniqueidentifier] NOT NULL,
[SchoolID] [uniqueidentifier] NOT NULL,
[FirstName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Username] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Deleted] [bit] NOT NULL,
CONSTRAINT [PK_table_athlete] PRIMARY KEY NONCLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

FILTER:

[ID] IN (SELECT AthleteID FROM table_roster WHERE [AthleteID] = [ID] AND
SSID IN (SELECT [ID] FROM table_sportseason WHERE ISNULL(InternalArchive, 0)
= 0))

Thanks,

Mark


.

Relevant Pages