sp_fulltext_column on Image datatype.

  • I have table which has column of Image data type.I want to create a full-text image on this column.I created the catalog, and tried to add the column to the catalog but it is giving error please help me.I used the same query for other column of datatype varchar in same table it got created but for column of image datatype it does not work.

    EXEC sp_fulltext_column '@tablename','@column_name','add'

    Server: Msg 15600, Level 15, State 1, Procedure sp_fulltext_column, Line 180

    An invalid parameter or option was specified for procedure 'sp_fulltext_column'.

  • Why would you want to create a full text index on an Image data type... doesn't it contain binary data?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply