Microsoft August 2025 Patch Tuesday Audit

[Walker12]

Good morning All,

Seeking some help with installing the patch Tuesday Report Script. Here is the error:

Try_Convert' is not a recognized built-in function name. 'Try_Convert' is not a recognized built-in function name. Incorrect syntax near the keyword 'As'. Incorrect syntax near the keyword 'As'. Incorrect syntax near the keyword 'As'. Incorrect syntax near the keyword 'As'. Incorrect syntax near the keyword 'As'. Incorrect syntax near the keyword 'As'.

[Walker12 · Accepted solution]

TRY_CONVERT is only available in SQL Server 2012 and later. Replace TRY_CONVERT with CONVERT.

[Cultus-EDV]

We are using SQL Server 2019 and we do get this error as well. So, why do Lansweeper use this new command instead of the old one?