PRB: Error 1927: "There Are Already Statistics on Table <Table_Name> Named <Statistics_Name>" (815063)
The information in this article applies to:
SYMPTOMSWhen you publish a table that you created statistics for by
using the CREATE STATISTICS statement, and then you reinitialize the
Subscriber, the Distribution Agent may fail and you receive the following error
message: Error 1927 - There are already statistics on
table tablename named
statisticsname. WORKAROUNDTo work around this problem, do not replicate the
non-clustered indexes of the table:
- At the Publisher, start SQL Server Enterprise
Manager.
- Expand a server group, and then expand a server.
- Expand Databases, and then expand the name
of the database where the Distribution Agent fails.
- Expand Publications.
- Right-click a publication, and then click
Properties.
- On the Publication Name
Properties dialog box, click the Articles
tab.
- In the Specify the objects to publish as
articles list, double-click the article that the error occurred
for.
- In the Article Name
Properties dialog box, click the Snapshot
tab.
- Under Copy Indexes, click to clear the
Copy nonclustered indexes to the subscription table check box,
and then click OK.
- On Publication Name
Properties dialog box, click OK.
- Click Yes on the Save
changes dialog box.
| Modification Type: | Minor | Last Reviewed: | 3/2/2004 |
|---|
| Keywords: | kbnofix kbSysAdmin kberrmsg kbprb KB815063 kbAudDeveloper |
|---|
|