Are there any known compatibility issues when running Helpdesk/SupportCenter on MS SQL 2003 or later?
If running Helpdesk on MS SQL server 2003 or later, the Helpdesk database needs to have it's compatibility level set to SQL Server 2000 (80). If this is not set to 80 you may experience errors when using Hot topics.
See books online for information on setting the database compatibility level.
Helpdesk/SupportCenter All Versions