• Welcome to Support Forum: Get Support for Patch My PC Products and Services.
 
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Unikom

#1

Hello!

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

Quote from: Justin Chalfant on January 20, 2020, 07:51:27 AM
Do you at least test one query on 2017 with 110 compatibility to see if it helped?

Quote from: Unikom on January 20, 2020, 01:30:05 AM
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
#2
Yes i did and it worked, sorry, should have written that in my previous post.
#3
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