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

Stored procedure depends on Full-text Index - SQL Compare

Dear RedGate,

We are currently creating model scripts of our Database that includes Full Text indexes. And one of our Stored procedures depend on those indexes.

I get the following error : 
Msg 7601, Level 16, State 2, Procedure pr_Search, Line 55
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'table_name' because it is not full-text indexed.
I think SQL Compare ignored the relationship between our Stored procedure and the full-text index. If i copy the Create part for our Stored procedure after the creating of the fulltext index the scripts works fine.

Thanks in advance,

Tim Ververs
Communited
Tim Ververs
0

Comments

3 comments

Sort by
  • Eddie D
    Thank you for your forum post and sorry for the delay in replying back to you.

    The problem you have encountered is known problem. I have added the details of this forum post to an existing Bug Report whose reference is SC-1196. Sadly it appears that the Development Team are having a few problem fixing this problem and therefore sadly I cannot provide an ETA as to when this issue will be fixed.

    Many Thanks
    Eddie
    Eddie D
    0
  • TimVervers
    I saw that SC-1196 was fixed. Will there be an ETA for this solution?
    TimVervers
    0
  • Mike U
    Yes, SC-1196 was fixed in version 11.2, at the beginning of May (see http://documentation.red-gate.com/display/SC11/SQL+Compare+11.2+release+notes), which means that dependencies on full text indexes are now correctly handled.

    Note that you need to use the option to turn transactions off; this is due to the SQL Server limitation that full text indexes and catalogs cannot be modified within a transaction.
    Mike U
    0

Add comment

Please sign in to leave a comment.