FIX: Incorrect results occur when you convert "pollinginterval" parameter from seconds to hours in sys.sp_cdc_scan in SQL Server

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core


Assume that you enable the Change Data Capture (CDC) feature on a table to run a log scan in Microsoft SQL Server. The pollinginterval parameter is converted from seconds (s) to hours (h) in the sys.sp_cdc_scan stored procedure. However, when the pollinginterval parameter is greater than one hour (>3600 s), you notice that the converted result is incorrect. 


This problem is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 12 for SQL Server 2017

       Cumulative Update 3 for SQL Server 2016 SP2

       Cumulative Update 12 for SQL Server 2016 SP1

       Cumulative Update 1 for SQL Server 2014 SP3

       Cumulative Update 14 for SQL Server 2014 SP2


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


Learn about the terminology that Microsoft uses to describe software updates.