Stored procedure depends on Full-text Index - SQL Compare

TimVerversTimVervers Posts: 13 New member
edited June 30, 2015 4:31PM in SQL Compare 11
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


Sign In or Register to comment.