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

The information in this article applies to:

Microsoft SQL Server 7.0

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.

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug KB250604