>>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)