FILESTREAM & Sp_filestream_configure
This will the first of several post on Filestream as I look into implementing on a system used for documentation storage.
FILESTREAM & sp_filestream_configure
— Pre RTM release of SQL the stored procedure sp_filestream_configure existed
— for the configuration of the FILESTREAM settingsm there are a variety of example
— out on the web referencing this stored procedure
— this has been removed, even though it still turns red, on the RTM version
EXEC sp_filestream_configure @Enable_level=2, @Sharename =’SQL2008′
–This is now controlled through sp_configure
–You will need to enable advanced options if not already set
sp_configure ‘show advanced options’, 1
–This functionaly is now in the filestream_access_level option
–Values for this option are set out below
0 Disables FILESTREAM support for this instance.
1 Enables FILESTREAM for Transact-SQL access.
2 Enables FILESTREAM for Transact-SQL and Win32 streaming access.
–Example of enabling FILESTREAM for TSQL and WIN32 Access
EXEC sp_configure filestream_access_level, 2
Author Martin Croft
Tags: FILESTREAMYou can comment below, or link to this permanent URL from your own site.