Configuration.FilestreamAccessLevel Property
SQL Server 2012
Gets the ConfigProperty object that sets the FILESTREAM access level configuration option.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Property Value
Type: Microsoft.SqlServer.Management.Smo.ConfigPropertyA ConfigProperty object that specifies the settings for the FILESTREAM access level configuration option.
The following example displays the currently configured FILESTREAM access level for the local instance of SQL Server.
Power Shell
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$configProperty = $dbServer.Configuration.FilestreamAccessLevel
Write-Host $configProperty.DisplayName " = " $configProperty.ConfigValue
C#
using System;
using System.Text;
using Microsoft.SqlServer.Management.Smo;
namespace SmoConfigurationProperty
{
class Program
{
static void Main(string[] args)
{
Server server = new Server("(local)");
ConfigProperty cfgProperty =
server.Configuration.FilestreamAccessLevel;
Console.WriteLine("{0} = {1}\n",
cfgProperty.DisplayName,
cfgProperty.ConfigValue);
}
}
}
