"Incorrect syntax near the keyword 'IF'"

This error would be present on the Community Homelessness Report (CHR) and others. Most likely, this is related to a DROP TABLE IF EXISTS command, relating to a temporary table. This command is only recognized in MS SQL Server 2016 and up.

See https://www.mssqltips.com/sqlservertip/6769/sql-server-drop-table-if-exists/