Stored procedure depends on Full-text Index - SQL Compare
TimVervers
Posts: 13 New member
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 :
Thanks in advance,
Tim Ververs
Communited
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
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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.
Redgate Software