Partager via


Propriété Configuration.FilestreamAccessLevel

Gets the ConfigProperty object that sets the FILESTREAM access level configuration option.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public ReadOnly Property FilestreamAccessLevel As ConfigProperty 
    Get
'Utilisation
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

Valeur de propriété

Type : Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the FILESTREAM access level configuration option.

Notes

The FilestreamAccessLevel property sets the FILESTREAM access level configuration option

Exemples

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

Voir aussi

Référence

Configuration Classe

Espace de noms Microsoft.SqlServer.Management.Smo

Autres ressources

Vue d'ensemble de FILESTREAM

Options de configuration de serveur

sp_configure (Transact-SQL)