How to read value of clr strict security value in c#( using smo)

janardhan g 1

I am able to access "IsSqlClrEnabled"(EXEC sp_configure 'clr enabled', 1;)
using this.ServerInstance.Configuration.IsSqlClrEnabled.ConfigValue; statement in C#,

how do i get value of 'clr strict security' ( SELECT * FROM sys.configurations WHERE name LIKE 'clr strict security';) in C# SMO latest version (161.46367.54)

1 answer

Karen Payne MVP 35,401 Reputation points

2021-06-11T15:14:55.12+00:00

Code sample located here will do this.
Please sign in to rate this answer.
Solomon Rutzky 31 Reputation points

2021-06-14T16:09:21.113+00:00

Hi Karen. The O.P. states that they can already get this property (i.e. "IsSqlClrEnabled"). It is the "clr strict security" option (introduced in SQL Server 2017) that they are looking to access, and that does not appear to be exposed via SMO.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to read value of clr strict security value in c#( using smo)

1 answer

Your answer