cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MSSQL Server CLR setting for the App Portal 2022R1 database

Do we need to enable the MSSQL Server CLR for the App Portal 2022R1 database? Is it mandatory?

(1) Reply
CharlesW
By Level 12 Flexeran
Level 12 Flexeran

I don't believe that we've every actually tested App Broker to see if disabling SQL CLR causes problems. It is always enabled by default as far as I can tell. I looked over some of the stored procedures and functions used by App Broker, and I did not see anything that looked like it would require the CLR. Furthermore, I ran the following query, and did not see any assembly references other than microsoft.sqlserver.types.dll, which is unrelated to App Broker:

SELECT *
FROM sys.assembly_files
WHERE [file_id] = 1;

Thanks
Charles