BUG: Snapshot Replication Requires Primary Key Constraint (160869)
The information in this article applies to:
This article was previously published under Q160869
BUG #: 12252 (NT)
SYMPTOMS
The "Snapshot Replication" section in Part Three, "What's New for
Administrators," of the "What's New for SQL Server 6.5" guide states the
following:
To enable snapshot replication to tables without primary keys, run the
sp_addarticle stored procedure to create the articles; the table names
will not appear in the Article Table list if they do not have a declared
primary key.
However, the stored procedure, sp_addarticle, only allows "log based" types
of articles to be created (which require a primary key to exist on the table).
WORKAROUND
Create a primary key constraint on any table to be published.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. We are researching this problem and will post new information
here in the Microsoft Knowledge Base as it becomes available.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug KB160869 |
|---|
|