Messages

Hello!

Any updates regarding the issue with Compatibility level of the database?

Do you at least test one query on 2017 with 110 compatibility to see if it helped?

Hi, we have the same issue, we know what is causing it, the problem is the Compatibility level of the database, when set to 110 mode the Reports work for us, we did this when we had SQL 2014 as base but do not want to do this now on SQL 2017.

Can anyone from Patch My PC do a overhaul of the reports so that it can run the latest compatibility level on the database.

More info from MS regarding CM and SQL compatibility levels.

https://support.microsoft.com/en-us/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d

Yes i did and it worked, sorry, should have written that in my previous post.

Hi, we have the same issue, we know what is causing it, the problem is the Compatibility level of the database, when set to 110 mode the Reports work for us, we did this when we had SQL 2014 as base but do not want to do this now on SQL 2017.

Can anyone from Patch My PC do a overhaul of the reports so that it can run the latest compatibility level on the database.

More info from MS regarding CM and SQL compatibility levels.

https://support.microsoft.com/en-us/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d