Microsoft KB Archive/247492

= FIX: Primary Key Can Be Dropped if Table is Published =

Article ID: 247492

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q247492



BUG #: 56582 (SQLBUG_70)



SYMPTOMS
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:

Publisher: {call sp_replcmds (500)}

Status: 0, code: 0, text: 'The process could not execute 'sp_replcmds' on '%s'.'.

The process could not execute 'sp_replcmds' on '%s'.

Status: 0, code: 18756, text: 'Could not get replication information for table %d'.



WORKAROUND
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.



STATUS
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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.