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

Explore posts in the same categories: FILESTREAM


You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: