Field level security on more than 5 fields CRM On Prem 2015. SQL Server 2014

(0) Share

Report

Posted on by gman0104

821

I'm getting SQL timeout issue when opening a record that has more than 5 secured fields (via Field Level Security) Has anyone came across this bug and it there a fix for it at all. I've read somewhere that if the SQL server database compatibility level is set to a value higher than 110, the SQL query optimizer incorrectly estimates the number of records causing the SQL Server Time out. Is it advisable to set the compatibility level back from 120 to 110 or will this cause issues with CRM

Thanks in advance

*This post is locked for comments