BUG: Merge Snapshot Fails with "Line 1: Incorrect syntax near '[Object Name>]'."

ID: Q248135

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55374 (SQLBUG_70)

SYMPTOMS

The merge snapshot agent fails and reports the following error:

Line 1: Incorrect syntax near '[Partial Object Name]'.

CAUSE

When a large number of tables are joined together in a publication, the table names are concatenated together into a large view name. If this large view name exceeds 2000 characters, the merge snapshot fails with a syntax error. The error is different depending on where the view name is truncated.

STATUS

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

Additional query words:

Keywords : SSrvRep kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug