SQL Server 2008 -- File Stream (1)

●FILESTREAM is disabled by default in SQL Server 2008, and you must first enable it before the feature can be used.

●Two step to enable FILESTREAM

1.Enabling FILESTREAM for the Machine

2.Enabling FILESTREAM for the Server Instance

EXEC sp_configure filestream_access_level, n RECONFIGURE

Note: The value 0 disables the FILESTREAM feature completely. Setting the access level to 1 enables FILESTREAM for T-SQL access only, and setting it to 2 enables FILESTREAM for full access (which includes local or remote file I/O streaming access as enabled for the machine in the first step). To support our sample .NET applications that will demonstrate file I/O streaming access using OpenSqlFilestream, you'll need to select level 2 (full access).