Server.FilestreamLevel Server.FilestreamLevel Server.FilestreamLevel Property

Definition

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

public:
 property Microsoft::SqlServer::Management::Smo::FileStreamEffectiveLevel FilestreamLevel { Microsoft::SqlServer::Management::Smo::FileStreamEffectiveLevel get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone)]
public Microsoft.SqlServer.Management.Smo.FileStreamEffectiveLevel FilestreamLevel { get; }
Public ReadOnly Property FilestreamLevel As FileStreamEffectiveLevel
Property Value

A FileStreamEffectiveLevel object that specifies what types of streaming access are enabled on the instance of SQL Server.

Examples

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  

Remarks

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

Applies to