Article ID: 298951 - View products that this article applies to.
This article was previously published under Q298951
BUG #: 352765 (SHILOH_bugs)
BUG #: 353201 (SHILOH_bugs)
When you run the Snapshot Agent for a merge publication that has join filters and column partitions (also referred to as "vertical partitions" or "vertical filters"), the Snapshot Agent may fail with the following 107 error message:
"The column prefix '%.*ls' does not match with a table name or alias name used in the query".
While creating the snapshot, the sp_MSpublicationview stored procedure fails when creating a view that references the table names used in the join_filter clause:
( view name = <publication name> + '_' + <article_name> + '_VIEW' )
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
HotfixNOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.
The English version of this fix should have the following file attributes or later:
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
Date Time Size File name -------------------------------------------- 03/26/2001 08:22p 3,298 Readme.txt 03/26/2001 06:26p 952,448 Replmerg.sql
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 1.