What are the challenges you face when working across database platforms? Take the survey

Full-text indexing bug when used with image columns

grantphgrantph Posts: 7
edited April 28, 2005 1:25PM in SQL Compare Previous Versions
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

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'

I'm running version 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!




  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
This discussion has been closed.