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

Server.FilestreamLevel Property

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)

[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 Filestream Overview.

C#

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

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
Write-Host "The file stream access level is:" $srv.FileStreamLevel
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft