VS Data Pro bug with FULLTEXT INDEX with varbinary(max)
I think I have found a bug in VS Data Pro that deals with FULLTEXT indexes with varbinary(max) columns.
When I add an index to the table like...
CREATE
FULLTEXTINDEX ON[Greenstone].[FileAttachment]KEY INDEX[PK_FileAttachment]ON[MainFullTextCatalog]ALTER
FULLTEXTINDEX ON[Greenstone].[FileAttachment]ADD(FileNameLANGUAGE0)ALTER
FULLTEXTINDEX ON[Greenstone].[FileAttachment]ADD(ImageData TYPECOLUMNFileExtensionLANGUAGE0)When the database script is generated the "TYPE COLUMN FileExtesion" is removed.
CREATE
FULLTEXTINDEX ON[Greenstone].[FileAttachment]KEY INDEX[PK_FileAttachment]ON[MainFullTextCatalog]ALTER
FULLTEXTINDEX ON[Greenstone].[FileAttachment]ADD(FileNameLANGUAGE0)ALTER
FULLTEXTINDEX ON[Greenstone].[FileAttachment]ADD(ImageDataLANGUAGE0) Is this a know bug or am I writing the script incorrect. BTW: this also happens with "Data -> Schema Compare".
[2539 byte] By [KelvinHoover] at [2008-1-3] 