How can we help you today? How can we help you today?

Full-text indexing bug when used with image columns

Hello Support,

I have database table that uses full text indexes on image columns. When using image columns, SQL Server requires a second column indicating the extension. Example: Data image, DataExt char(4)

When SQL Compare generates script to update a second database it writes something like this:

-- Full text information
....
sp_fulltext_column N'[dbo].[t_Table]', N'Data', 'add', 1033
GO
....

This subsequently throws an error as the sp_fulltext_column stored proc is missing a parameter - the extension. It should read:

-- Full text information
....
sp_fulltext_column N'[dbo].[t_Table]', N'Data', 'add', 1033, N'DataExt'
GO
....

I'm running version 3.1.8.276 I have been able to work around the problem by running the script in QA and making manual modifications but its becoming a nuisance bug as our databases grow.

Otherwise, the product has been excellent!

Regards,

Grant.
grantph
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hello Grant,

    Thanks for pointing this out. We are currently working on a fix for this. Full-text indexes work just fine for text, but for image columns, the necessary final parameter is missing in the script produced by SQL Compare.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.