Microsoft KB Archive/815063

= PRB: Error 1927: &quot;There Are Already Statistics on Table  named.



WORKAROUND
To work around this problem, do not replicate the non-clustered indexes of the table:
 * 1) At the Publisher, start SQL Server Enterprise Manager.
 * 2) Expand a server group, and then expand a server.
 * 3) Expand Databases, and then expand the name of the database where the Distribution Agent fails.
 * 4) Expand Publications.
 * 5) Right-click a publication, and then click Properties.
 * 6) On the   Properties dialog box, click the Articles tab.
 * 7) In the Specify the objects to publish as articles list, double-click the article that the error occurred for.
 * 8) In the   Properties dialog box, click the Snapshot tab.
 * 9) Under Copy Indexes, click to clear the Copy nonclustered indexes to the subscription table check box, and then click OK.
 * 10) On   Properties dialog box, click OK.
 * 11) Click Yes on the Save changes dialog box.



MORE INFORMATION
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

252375 FIX: Pull Subscribers Unsynchronized if Reinitialized from Subscriber Causing Distribution Failures

When you contact Microsoft Product Support Services (PSS) for assistance, the PSS Support Professional working on your case may request for additional information specific to your environment. Please refer the following Microsoft Knowledge Base article link for more information before you contact the PSS Support Professional.

315642 INF: Information That PSS Needs to Troubleshoot SQL Server Replication

Keywords: kberrmsg kbnofix kbsysadmin kbprb KB815063

-

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

© Microsoft Corporation. All rights reserved.