Developer technologies | C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
Code sample located here will do this.
How to read value of clr strict security value in c#( using smo)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 4%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
janardhan g
1
Reputation point
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)
Developer technologies | C#
1 answer
Sort by: Most helpful
-
Karen Payne MVP 35,606 Reputation points Volunteer Moderator2021-06-11T15:14:55.12+00:00 -
Solomon Rutzky 31 Reputation points2021-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 -