Data Retention fix for SELECTserver 9

SELECTserver 9 introduced a Data Retention feature that can remove old usage data after a certain time period, limiting the growth of a license database. However, this feature has proven ineffective, producing truncation errors when invoked during usage log processing instead. While the errors do not affect the operation of SELECTserver itself, they indicate that the removal of old usage data failed. The following SQL script, when applied to the license database, will update a stored procedure to fix the feature.

The SQL script can be applied using SQL Server Management Studio, a free utility provided by Microsoft. Database administration tasks such as this one are best performed by a database administrator (DBA). If uncomfortable with such tasks, please disable the Data Retention feature to eliminate the errors instead.

Related
Recommended