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 >>>>>
>.... >) ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1] >But then, if I understand it correctly I won't use the FileStream, which is what I want to do. I found the original article where I got this from and they don't have the TEXTIMAGE_ON clause and that lets it work. It's weird that the TEXTIMAGE_ON was generated by SSMS from another table if it doesn't work.