>>>I am trying to create a table to use the FILESTREAM stuff in SQL Express 2008. Here's my code:
>>>
>>>

CREATE TABLE [dbo].[ClaimDocuments](
>>>	[doc_PK] [uniqueidentifier] NOT NULL,
>>>	[doc_desc] [varchar](100) NOT NULL,
>>>	[doc_clmfk] [uniqueidentifier] NOT NULL,
>>>	[doc_FileGUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
>>>	[doc_file] [varbinary](max) FILESTREAM NOT NULL,
>>> CONSTRAINT [PK_ClaimDocuments] PRIMARY KEY CLUSTERED 
>>>(
>>>	[doc_PK] ASC
>>>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
>>>) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1]
>>>
>>>GO

>>>
>>>Note that the last field is varbinary(max).
>>>
>>>I am getting this error:
>>>
>>>Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns.
>>>
>>>Can someone help me see the trees rather than the forest, please?
>>
>>
>>Can't test this right now, but I think you need UNIQUE ROWGUIDCOL:
>>

>>CREATE TABLE [dbo].[ClaimDocuments](
>>	[doc_PK] [uniqueidentifier] NOT NULL,
>>	[doc_desc] [varchar](100) NOT NULL,
>>	[doc_clmfk] [uniqueidentifier] NOT NULL,
>>	[doc_FileGUID] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
>>	[doc_file] [varbinary](max) FILESTREAM NOT NULL,
>> CONSTRAINT [PK_ClaimDocuments] PRIMARY KEY CLUSTERED 
>>(
>>	[doc_PK] ASC
>>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
>>) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1]
>>
>>GO
>>

>
>Thanks but that didn't make a difference (assuming it was just adding the word UNIQUE to the doc_FileGUID field)

I can't test it right now.
But from Google I saw that you could remove this clause :-)

....
) ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1]