We are leaving Russia. We are against aggression and war with Ukraine. It is a tragedy for our nations, it is a nightmare

Run HangFire in SQL Server 2005

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