Execute the following script to turn on the FILESTREAM facility on the current server instance. You can also use Object Explorer GUI to configure it. The FILESTREAM feature, new to SQL Server 2008, provides a way to store and access large ( > 2GB) binary values, either through SQL Server or by direct access to the Windows NTFS file system. It can be used for smaller varbinary(max) storage as well.

USE Master

Go

EXEC sp_configure 'filestream access level', 2

Go

RECONFIGURE

Go