Online Documentation for SQL Manager for SQL server
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.
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.
Disable FILESTREAM support for this instance
Check this option to disable FILESTREAM feature for handling unstructured data.
Enable FILESTREAM for Transact-SQL access
Enable this option to manage FILESTREAM data with Trancast-SQL statements (insert, update, query, search, and back up).
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.
Contained Database is independent of the SQL Server Instance. All the database metadata and user information is stored inside the database itself.
Allow contained database authentication
If this option is checked then contained databases can be created, or attached to the Database Engine.