Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: sp_addmergearticle May Fail with Error 20009 if Article Added Is Vertically Filtered
Article ID: 300172 - View products that this article applies to.
This article was previously published under Q300172
BUG #: 236010 (SHILOH_BUGS)
Adding an article to a publication using sp_addmergearticle may result in the following error:
This error can occur if all the following conditions are true:
Msg 20009, Level 16, State 1, Server 'servername', Procedure sp_addmergearticle, Line 1202
The article 'articlename' could not be added to the publication 'publicationname'.
To resolve this problem, obtain the latest service pack for 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
To work around this problem, you can do either of the following things before sp_addmergearticle is run:
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.