Aracılığıyla paylaş


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

'Bildirim
Public ReadOnly Property FilestreamAccessLevel As ConfigProperty
    Get
'Kullanım
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

Configuration Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DEL - FILESTREAM Overview

Server Configuration Options

sp_configure (Transact-SQL)