FYI:
In case you are using SCCM with SQL Server 2019 and are seeing the following error when opening some of the Reports. 
<blockquote>
EXECUTE permission was denied on the object 'fnlsCas'
</blockquote>
Just install following SQL Server 2019 hotfix <a target="_blank" href="https://support.microsoft.com/en-us/topic/kb4538581-fix-scalar-udf-inlining-issues-in-sql-server-2019-f52d3759-a8b7-a107-1ab9-7fbee264dd5d">KB4538581</a> and you are good to go 👍

FYI:

In case you are using SCCM with SQL Server 2019 and are seeing the following error when opening some of the Reports. 

> 
EXECUTE permission was denied on the object 'fnlsCas'


Just install following SQL Server 2019 hotfix [KB4538581](https://support.microsoft.com/en-us/topic/kb4538581-fix-scalar-udf-inlining-issues-in-sql-server-2019-f52d3759-a8b7-a107-1ab9-7fbee264dd5d) and you are good to go 👍

SCCM error EXECUTE permission was denied on the object 'fnlsCas'

The solution to the SCCM error "EXECUTE permission was denied on the object 'fnlsCas'" when opening some of the Reports

It's definitely not needed to send any donations, but in case you want to thank me for stuff I am sharing, you can. It will be definitely appreciated :)

It's definitely not needed to send any donations, but in case you want to thank me for stuff I am sharing, you can. It will be definitely appreciated :)