Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Use the filestream_access_level
option to change the FILESTREAM access level for this instance of SQL Server.
Note
Before this option has any effect, the Windows administration settings for FILESTREAM must be enabled. You can enable these settings when you install SQL Server or by using SQL Server Configuration Manager.
Value | Definition |
---|---|
0 |
Disables FILESTREAM support for this instance. |
1 |
Enables FILESTREAM for Transact-SQL access. |
2 |
Enables FILESTREAM for Transact-SQL and Win32 streaming access. |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Implement Windows Server File Server high availability - Training
Implement Windows Server File Server high availability
Documentation
Enable and configure FILESTREAM - SQL Server
To use FILESTREAM, first enable it on the SQL Server Database Engine instance. Learn how to enable FILESTREAM by using SQL Server Configuration Manager.
Move a FILESTREAM-enabled database - SQL Server
Discover how to move a FILESTREAM-enabled database. See which Transact-SQL scripts to use in the Query Editor of SQL Server Management Studio.
FILESTREAM compatibility - SQL Server
FILESTREAM stores data in the file system. Read about guidelines, limitations, and tips to keep in mind when using FILESTREAM with various SQL Server features.