Microsoft KB Archive/247492
Article ID: 247492
Article Last Modified on 3/14/2006
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q247492
BUG #: 56582 (SQLBUG_70)
Publishing a table for transactional replication relies on a primary key constraint being created on that table. However, after replication has been set up, it is possible to drop the constraint. This should not be allowed and it results in the logreader task failing with the following errors displayed in the logreader log:
To work around this problem, do not alter or drop the primary key constraint for a table that is published for transactional replication. If the primary key for a table must be altered, the table must be unpublished and then re-published.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
Keywords: kbbug kbfix KB247492