Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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)

public ConfigProperty FilestreamAccessLevel { get; }

Property Value

Type: 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);
        }
    }
}
Return to top
Show:
© 2016 Microsoft