This originates from the two statements at lines 39 and 71 of the integritycheck.php file version 9185:

$sQuery = "show tables like '{$dbprefix}survey_%'";

and

$sQuery = "show tables like '{$dbprefix}tokens_%'";

are indeed invalid SQL statements for MSSQL.

The mssql correct related statements are respectively:
$sQuery = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE' and TABLENAME LIKE '{$dbprefix}survey\%'";
and
$sQuery = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE' and TABLENAME LIKE '{$dbprefix}tokens\%'";

Adding a condition to check the databasedriver used is therefore ideal to obtain in the end something like:

if ($databasetype=='mssqlnative' || $databasetype=='odbc_mssql') {
$sQuery = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE' and TABLENAME LIKE '{$dbprefix}survey_%'";
} else { $sQuery = "show tables like '{$dbprefix}survey\%'";}

You obviously will have a better way of implementing the fix :))