Configuration.FilestreamAccessLevel Property
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)
Syntax
'Declaration
Public ReadOnly Property FilestreamAccessLevel As ConfigProperty
Get
'Usage
Dim instance As Configuration
Dim value As ConfigProperty
value = instance.FilestreamAccessLevel
public ConfigProperty FilestreamAccessLevel { get; }
public:
property ConfigProperty^ FilestreamAccessLevel {
ConfigProperty^ get ();
}
member FilestreamAccessLevel : ConfigProperty
function get FilestreamAccessLevel () : ConfigProperty
Property Value
Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the FILESTREAM access level configuration option.
Remarks
The FilestreamAccessLevel property sets the FILESTREAM access level configuration option
Examples
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);
}
}
}
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace