It would be useful if the ILP 2.0 had support for the MS SQL Database. The following script has 6 lines with "SHOW TABLES LIKE.."

https://github.com/ULCC/moodle-block_ilp/blob/master/db/ilp_db.php

example:

$tableexists = $this->dbc->get_records_sql("SHOW TABLES LIKE '

'");

Which is giving me at least the error:

[11:19:24] sqlsrv_query: message = [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'LIKE'.