FIX: ObjectPropertyEx returns incorrect row count when there are partitions in a database object

Applies to: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core More

Symptoms


Assume that you have many partitions in a database object in an instance of Microsoft SQL Server 2014 and 2017. When you call the ObjectPropertyEx function against the database object that has the property name set to Cardinality, the function returns the row count from the first partition only rather than from all the partitions of the object.

Resolution


The fix for this issue is included in the following updates for SQL Server:

          Cumulative Update 13 for SQL Server 2017

Cumulative Update 1 for SQL Server 2014 Service Pack 3

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.