TechNet
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 T:Microsoft.SqlServer.Managmement.Smo.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
Return to top
Show:
© 2016 Microsoft