Service Pack 1 Breaks SQL Express Replication Subscriptions -- sql server replication

theBainster
9/21/2006 12:00:00 AM

We have SQL Server 2005 Standard Edition with several (around 75)
replication subscribers (SQL Server Express). After applying Service Pack 1
to the Publisher, about 80% of the subscriptions became invalidated. Simply
reinitializing the subscription did not work. The entire subscription had
to be set up all over again.

Being that these were laptop pull subscriptions, this was a major headache.

Subscriptions on other SQL Server 2005 Standard Edition servers were
unaffected.

Has anyone had this problem?

Bryan

Hilary Cotter
9/21/2006 10:02:42 AM

Sorry, haven't seen this one.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Service Pack 1 Breaks SQL Express Replication Subscriptions