Thanks again, you have been most helpful. I have identified the query causing the issue and I will try using the hint to see if that resolves the issue.

Thank you for your response. I appreciate it.

If I leave that database in 2008 compatibility mode will I still be able to utilize all of the 2016 functionality such as...