Chirag (9/3/2009)

---

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