Do we need to enable the MSSQL Server CLR for the App Portal 2022R1 database? Is it mandatory?
‎Jul 13, 2023 02:26 AM
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
‎Jul 20, 2023 08:54 AM