SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
Server Class
Server Properties
ActiveDirectory Property
AffinityInfo Property
AuditLevel Property
Audits Property
AvailabilityGroups Property
BackupDevices Property
BackupDirectory Property
BrowserServiceAccount Property
BrowserStartMode Property
BuildClrVersion Property
BuildClrVersionString Property
BuildNumber Property
ClusterName Property
ClusterQuorumState Property
ClusterQuorumType Property
Collation Property
CollationID Property
ComparisonStyle Property
ComputerNamePhysicalNetBIOS Property
Configuration Property
ConnectionContext Property
Credentials Property
CryptographicProviders Property
Databases Property
DefaultFile Property
DefaultLog Property
DefaultTextMode Property
Edition Property
Endpoints Property
EngineEdition Property
ErrorLogPath Property
Events Property
FilestreamLevel Property
FilestreamShareName Property
FullTextService Property
HadrManagerStatus Property
Information Property
InstallDataDirectory Property
InstallSharedDirectory Property
InstanceName Property
IsCaseSensitive Property
IsClustered Property
ISfcDomainLite.DomainInstanceName Property
ISfcDomainLite.DomainName Property
ISfcHasConnection.ConnectionContext Property
ISfcSupportsDesignMode.IsDesignMode Property
IsFullTextInstalled Property
IsHadrEnabled Property
IsSingleUser Property
JobServer Property
Language Property
Languages Property
LinkedServers Property
LoginMode Property
Logins Property
Mail Property
MailProfile Property
MasterDBLogPath Property
MasterDBPath Property
MaxPrecision Property
Name Property
NamedPipesEnabled Property
NetName Property
NumberOfLogFiles Property
OleDbProviderSettings Property
OSVersion Property
PerfMonMode Property
PhysicalMemory Property
PhysicalMemoryUsageInKB Property
Platform Property
Processors Property
ProcessorUsage Property
Product Property
ProductLevel Property
ProxyAccount Property
ResourceGovernor Property
ResourceLastUpdateDateTime Property
ResourceVersion Property
ResourceVersionString Property
Roles Property
RootDirectory Property
ServerAuditSpecifications Property
ServerType Property
ServiceAccount Property
ServiceInstanceId Property
ServiceMasterKey Property
ServiceName Property
ServiceStartMode Property
Settings Property
SqlCharSet Property
SqlCharSetName Property
SqlDomainGroup Property
SqlSortOrder Property
SqlSortOrderName Property
Status Property
SystemDataTypes Property
SystemMessages Property
TapeLoadWaitTime Property
TcpEnabled Property
Triggers Property
UserDefinedMessages Property
UserOptions Property
Version Property
VersionMajor Property
VersionMinor Property
VersionString Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Server.FilestreamLevel Property

SQL Server 2012

Gets the level of FILESTREAM access specified on the instance of SQL Server.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public FileStreamEffectiveLevel FilestreamLevel { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.FileStreamEffectiveLevel
A StreamAccessLevel object that specifies what types of streaming access are enabled on the instance of SQL Server.

File streaming can be enabled for Transact-SQL and Win32 file access. For more information, see DEL - FILESTREAM Overview.

C#

Copy 
Server srv = new Server("(local)");
Console.WriteLine("The file stream access level is: " + srv.FileStreamLevel.ToString());

PowerShell

Copy 
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
Write-Host "The file stream access level is:" $srv.FileStreamLevel
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.