Microsoft KB Archive/945066

= SQL Server 2005 does not validate all articles in a transactional publication when you run the sp_publication_validation stored procedure to validate the articles =

Article ID: 945066

Article Last Modified on 12/5/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition

-



SYMPTOMS
Consider the following scenario. You have a transactional publication in Microsoft SQL Server 2005. Some articles in the transactional publication have the column filtering feature enabled. You run the sp_publication_validation stored procedure to validate the articles in the transactional publication. In this scenario, SQL Server 2005 does not validate any articles that have an article ID that is larger than the article ID of first article in the transactional publication that has the column filtering feature enabled.



WORKAROUND
To work around this problem, use the sp_article_validation stored procedure to validate every article.

For example, you have a publication that is named my_publication. The publication contains four articles. The names of the articles are table_1, table_2, table_3, and table_4. You create a stored procedure that uses the sp_article_validation stored procedure to validate every article. For example, the stored procedure resembles the following code example. Create procedure sp_myvalidation As Execute sp_article_validation @publication = ‘my_publication’, @article = ‘table_1’ Execute sp_article_validation @publication = ‘my_publication’, @article = ‘table_2’ Execute sp_article_validation @publication = ‘my_publication’, @article = ‘table_3’ Execute sp_article_validation @publication = ‘my_publication’, @article = ‘table_4’ GO

EXEC sp_myvalidation GO



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbexpertiseadvanced kbtshoot kbprb KB945066

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.