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