public static void SetClr(SqlOnOffOptions onOffOption, string connectionString)
{
var sql = "EXEC sp_configure 'clr enabled', 1; " + Environment.NewLine +
"RECONFIGURE; ";
ExecuteSql(sql, connectionString);
}
public static void SetTrustworthy(SqlOnOffOptions onOffOption, string connectionString)
{
var sql = @"DECLARE @cmd NVARCHAR(MAX); " + Environment.NewLine +
"SET @cmd='ALTER DATABASE ' + QUOTENAME(DB_NAME()) + ' SET TRUSTWORTHY ON;'; " +
Environment.NewLine +
"EXEC(@cmd); ";
ExecuteSql(sql, connectionString);
}
