| title | sys.database_filestream_options (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.database_filestream_options (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 06/10/2016 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server]
Displays information about the level of non-transactional access to FILESTREAM data in FileTables that is enabled. Contains one row for each database in the SQL Server instance.
For more information about FileTables, see FileTables (SQL Server).
| Column | Type | Description |
|---|---|---|
| database_id | int | The ID of the database. This value is unique within the [!INCLUDEssNoVersion] instance. |
| directory_name | nvarchar(255) | The database-level directory for all FileTable namespaces. |
| non_transacted_access | tinyint | The level of non-transactional access to FILESTREAM data that is enabled. The level of access is set by the NON_TRANSACTED_ACCESS option of the CREATE DATABASE or ALTER DATABASE statement. This setting has one of the following values: 0 - Not enabled. This is the default value. This level is set by providing the value OFF for the NON_TRANSACTED_ACCESS option. 1 - Read-only access. This level is set by providing the value READ_ONLY for the NON_TRANSACTED_ACCESS option. 3 - Full access. This level is set by providing the value FULL for the NON_TRANSACTED_ACCESS option. 5 - In transition to READONLY 6 - In transition to OFF |
| non_transacted_access_desc | nvarchar(60) | The description of the level of non-transactional access identified in non_transacted_access. This setting has one of the following values: NONE - This is the default value. READ_ONLY FULL IN_TRANSITION_TO_READ_ONLY IN_TRANSITION_TO_OFF |