Microsoft KB Archive/278894

= BUG: Merge Replication Snapshot Agent Fails with Error Message 1913 =

Article ID: 278894

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Additional query words: sp_MSaddguid, 1913, merge, duplicate, index

Keywords: kbbug kbpending KB278894

-

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

© Microsoft Corporation. All rights reserved.