BUG: Merge Replication Snapshot Agent Fails with Error Message 1913 (278894)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q278894
BUG #: 100765 (SQLBUG_70)

SYMPTOMS

When trying to set up merge replication on a table that has an existing index on the ROWGUID column, the Merge Snapshot Agent fails and the following error message displays:
Error 1913:
There is already an index on table 'table_name' named 'tablename_165575628'.
This error only occurs for tables that are not owned by the dbo user.

CAUSE

The sp_MSaddguidindex stored procedure that is used by merge replication to add an index on the ROWGUID column fails to take into account the fully qualified owner name for the table.

WORKAROUND

Here are two workarounds you can use to avoid the error:
  • Prior to creating a Merge Publication, delete all the indexes on the ROWGUID column from the tables you want to publish.

    -or-

  • Change the owner of the tables to be the dbo user.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

MORE INFORMATION

This behavior has been fixed in Microsoft SQL Server 2000.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbDSupport KB278894
©2002 Microsoft Corporation. All rights reserved.