Microsoft KB Archive/152799

{|
 * width="100%"|

BUG: Filtered Stored Procedures for Horizontal Partitioning

 * }

Q152799

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
The Filtered Stored procedures used to facilitate Horizontal Partitioning in SQL Server 6.0 replication may not work when tables other than the one being published are involved in specifying the condition for the horizontal partition. The transaction fails to be recognized as a valid replicated transaction that should be distributed to the subscriber, even though the conditions for the horizontal partition are satisfied. The synchronization task has no problem in recognizing the satisfaction of the condition for partition. The logreader, however, reports in its history that it has processed a replicated transaction consisting of zero commands.

WORKAROUND
The entire table must be published without doing horizontal partitioning. If the partitioned data needs to be published, then you have to create a permanent table with the data from the original table selectively siphoned out (for instance, by using triggers with the partition condition) and then publish the new table.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words:

Keywords :

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600