I am seeing flames with using FILESTREAM in SQL Server 2008!
I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column.
This is what the script looks like:
CREATE TABLE PRODUCTS ( ProdID INT PRIMARY KEY, ProdName VARCHAR(40), ProdDescription VARCHAR(50), ProdCategory VARCHAR(20), StockOnHand INT, ProdPrice MONEY, ProdPicture VARBINARY(MAX) FILESTREAM )
I have looked up using FILESTREAM online, and came across a number of resources. I followed all the available instructions, even running the script for enabling filestream from within SQL Server, which looks like this:
EXEC SP_CONFIGURE FILESTREAM_ACCESS_LEVEL, 2 RECONFIGURE.
I tried to set the access level to 3 (which is what we need since we want to allow remote client access) which doesn't work.
I always seem to get the error 'Default FILESTREAM filegroup is not available in database'