共用方式為


Configuration.FilestreamAccessLevel 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public ReadOnly Property FilestreamAccessLevel As ConfigProperty 
    Get
'用途
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

屬性值

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

備註

The FilestreamAccessLevel property sets 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);
        }
    }
}

請參閱

參考

Configuration 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

FILESTREAM 概觀

伺服器組態選項

sp_configure (Transact-SQL)