Online Documentation for SQL Manager for SQL server

Advanced settings


The Advanced section of the Server Properties dialog allows you to configure the instance of Microsoft® SQL Server by setting advanced server options in groups: Filestream access level, Database containment.

 

Server Properties - Advanced

 

Filestream access level

 

FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data.

 

RadioButton Disable FILESTREAM support for this instance

Check this option to disable FILESTREAM feature for handling unstructured data.

 

RadioButton Enable FILESTREAM for Transact-SQL access

Enable this option to manage FILESTREAM data with Trancast-SQL statements (insert, update, query, search, and back up).

 

RadioButton Enable FILESTREAM for Transact-SQL and Win32 streaming access

Win32 file system interfaces provide I/O streaming access to the data. You can use Win32 to read and write data to a FILESTREAM BLOB.

 

Database containment

 

Contained Database is independent of the SQL Server Instance. All the database metadata and user information is stored inside the database itself.

 

CheckBox Allow contained database authentication

If this option is checked then contained databases can be created, or attached to the Database Engine.