When trying to install format, the following appears and cannot continue until I remove the files from server:

Debug info: SQLState: 42000<br>
Error Code: 156<br>
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'IDENTITY'.<br>

ALTER TABLE mdl_format_topcoll_settings ALTER COLUMN id BIGINT NOT NULL IDENTITY(1,1)
Error code: ddlexecuteerror
Stack trace:
line 413 of \lib\dml\moodle_database.php: ddl_change_structure_exception thrown
line 258 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
line 679 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
line 88 of \lib\ddl\database_manager.php: call to sqlsrv_native_moodle_database->change_database_structure()
line 77 of \lib\ddl\database_manager.php: call to database_manager->execute_sql()
line 575 of \lib\ddl\database_manager.php: call to database_manager->execute_sql_arr()
line 600 of \lib\ddl\database_manager.php: call to database_manager->change_field_type()
line 66 of \course\format\topcoll\db\upgrade.php: call to database_manager->change_field_unsigned()
line 471 of \lib\upgradelib.php: call to xmldb_format_topcoll_upgrade()
line 1524 of \lib\upgradelib.php: call to upgrade_plugins()
line 329 of \admin\index.php: call to upgrade_noncore()