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

I work as System Administrator for more than 10 years now and I love to make my life easier by automating work &amp; personal stuff via PowerShell. So why don't share it with everyone :)
