This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 471255 (SHILOH_BUGS)
Microsoft SQL Server 2000 fixes are distributed as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 fix release.
When you use a dynamic snapshot for merge replications, the dynamic Snapshot Agent may fail. Additionally, you may receive an incorrect syntax error message that is similar to the following:
SourceTypeId = 5 SourceName = MyMachine ErrorCode = 156 ErrorText = Incorrect syntax near the keyword 'from'. Incorrect syntax near the keyword 'from'.
When the dynamic snapshot is created, the dynamic Snapshot Agent tries to create views that are based on merge system tables and other views that are defined on the articles that are contained in the publication. During this process, the sp_MSmakedynsnapshotvws stored procedure incorrectly assumes that there will be only one row in the syscomments system table for any view that is defined on the articles in a publication. Therefore, if a view that is based on an article spans more than one row in the syscomments system table, the problem that is described in the "Symptoms" section occurs.
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Note Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.
After you apply this hotfix, the dynamic Snapshot Agent uses the sp_MSmakedynsnapshotvws stored procedure if all the views in the publication have no more than one row in the syscomments system table. If at least one view has more than one row in the syscomments system table, the dynamic Snapshot Agent uses the newly added sp_MSmakedynsnapshotvws_longdef procedure. The sp_MSmakedynsnapshotvws_longdef procedure can only handle up to two rows in the syscomments system table. If any views have more than two rows, you may receive the following error message:
ErrorCode = 21387 ErrorText = The expanded dynamic snapshot view definition of one of the articles exceeds the system limit of 3499 characters. Consider using the default mechanism instead of the dynamic snapshot for initializing the specified subscription.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates