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

GO

RECONFIGURE

–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

GO

RECONFIGURE

Author Martin Croft

Advertisements
Explore posts in the same categories: FILESTREAM

Tags:

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:

WordPress.com Logo

You are commenting using your WordPress.com 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: