Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Server.FilestreamLevel Property

 

Applies To: SQL Server 2016 Preview

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 .

Legacy Code Example

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:
© 2015 Microsoft