• While creating the table to store filestream data you have specified the filestream file group with the keyword "FILESTREAM_ON". Is it necessary because i did not find the same in BOL.

    -- Create the test table for FILESTREAM

    CREATE TABLE [dbo].[tFileStreamTest](

    [id] [int] IDENTITY(1,1) NOT NULL,

    [FileStreamTest] [varbinary](max) FILESTREAM NULL,

    [FileGUID] UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL

    UNIQUE DEFAULT NEWID()

    ) ON [PRIMARY]

    FILESTREAM_ON [FileStreamGroup1];

    GO

    "Keep Trying"