Microsoft KB Archive/250604

= BUG: FILLFACTOR on Published Table Makes Merge Replication to JET 4.0 Subscribers Fail with "Syntax error" Message =

Article ID: 250604

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q250604



BUG #: 57273 (SQLBUG_70)



SYMPTOMS
If a published table has FILLFACTOR on any of its indexes, the Merge agent fails with the following error, while applying the snapshot to JET 4.0 subscribers:

Last action: Invalid accessor

Category: Agent

Source: MS.Jet.4.0

Number: 3000

Full error message: Syntax error in CREATE TABLE statement.

NOTE: This behavior is not seen with SQL Server subscribers.



WORKAROUND
Here are two ways to work around this problem:  Do not use FILLFACTOR on the indexes of a table that is being merge published to JET 4.0 subscribers.

-or-  Before the Merge agent runs for the first time, edit the table_name.sch file for that table and remove the FILLFACTOR from the CREATE TABLE statement. You will find this file in the distributor's working directory, typically:

   MSSQL7\Repldata\UNC\PublishingServerName_PublishingDatabaseName_PublicationName\Timestamp 



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

Keywords: kbbug kbpending KB250604

-

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

© Microsoft Corporation. All rights reserved.