檔案資料流存取層級伺服器組態選項filestream access level Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

您可以使用 filestream_access_level 選項來變更這個 SQL ServerSQL Server執行個體的 FILESTREAM 存取層級。Use the filestream_access_level option to change the FILESTREAM access level for this instance of SQL ServerSQL Server.

注意

您必須先針對 FILESTREAM 啟用 Windows 管理設定,然後這個選項才會生效。Before this option has any effect, the Windows administration settings for FILESTREAM must be enabled. 當您安裝 SQL ServerSQL Server 或使用 SQL ServerSQL Server 組態管理員時,可以啟用這些設定。You can enable these settings when you install SQL ServerSQL Server or by using SQL ServerSQL Server Configuration Manager.

ReplTest1Value 定義Definition
00 針對這個執行個體停用 FILESTREAM 支援。Disables FILESTREAM support for this instance.
11 針對 Transact-SQLTransact-SQL 存取啟用 FILESTREAM。Enables FILESTREAM for Transact-SQLTransact-SQL access.
22 針對 Transact-SQLTransact-SQL 和 Win32 資料流存取啟用 FILESTREAM。Enables FILESTREAM for Transact-SQLTransact-SQL and Win32 streaming access.

另請參閱See Also

Database Engine 組態 - Filestream Database Engine Configuration - Filestream
啟用及設定 FILESTREAMEnable and Configure FILESTREAM