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

• Microsoft SQL Server version 7.0

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.

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 version 7.0.

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug