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:
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:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
NOTE: 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:
Date Time Size File name -------------------------------------------- 03/26/2001 08:22p 3,298 Readme.txt 03/26/2001 06:26p 952,448 Replmerg.sql
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
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.