A new Flexera Community experience is coming on November 25th. Click here for more information.
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