I need to run HangFire with Sql Server 2005. For now, I have the issue below, because de “forceseek” is available only from 2008.
Which version of HangFire I need to have to work with SqlServer 2005?
Error msg: “forceseek” is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.
Currently I am working one application using .Net Core to Sql Server 2005 express with hangfire reccuring jobs. But I am not able to open the connection it’s throwing me exception that
System.Data.SqlClient.SqlException: ‘“forceseek” is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.’
Anybody has any idea for solution for this problem?
It would be highly grateful to you