Filestream integrates the Database
Engine with your NTFS file system by storing BLOB data as files on the file
system and allowing you to access this data either using T-SQL or Win32 file
system interfaces to provide streaming access to the data.
Filestream uses the
Windows system cache for caching fi le data to help reduce any effect that filestream
data might have on SQL Server performance. The SQL Server buffer pool is not
used so that filestream does not reduce the memory available for query
processing.
Prior to setting this configuration option to indicate the
access level for filestream data, you must enable FILESTREAM
externally using the SQL Server Configuration Manager (if you haven’t enabled FILESTREAM
during SQL Server setup). Using the SQL Server Configuration Manager, you can
right-click the name of the SQL Server service and choose properties. The
dialog box has a separate tab for FILESTREAM options. You must check the top box to enable FILESTREAM for
T-SQL access, and then you can choose to enable FILESTREAM for
fi le I/O streaming if you want.
After enabling FILESTREAM for
your SQL Server instance, you then set the configuration value. The following
values are allowed:
0 Disables FILESTREAM support for this instance
1 Enables FILESTREAM for T-SQL access
2 Enables FILESTREAM for T-SQL and Win32 streaming access
