Share via

  • Article

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);
        }
    }
}