acre logo with name
⌘K
HIFIS Status
rReport Manager Errors
HIFIS Feedback
Favorites
History
HIFIS Status
HIFIS Report Errors › Report-Specific Errors

"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/ 

Completed
acre logo with name
ACRE Consulting Academy
Terms and conditions
Copyright © 2026 ACRE Consulting