Activity overview
Latest activity by cja100
Brian Donahue wrote:
You have to add the table or view to full-texct indexing. Unfortunately SQL Compare cannot check to make sure that this has been done so if you have an sp specifying a full-text query on a table that isn't full-text indexed, you will get an error.
You have to enable full-text indexing for the server and database and add each column using the sp_fulltext_column or sp_fulltext_table stored procedure.
I did that and its now working, thanks. / comments
Brian Donahue wrote:
You have to add the table or view to full-texct indexing. Unfortunately SQL Compare cannot check to make sure that this has been done so if you have an sp specifying a full-...
Cannot use a CONTAINS or FREETEXT predicate on table
I'm trying to use sql compare but I cannot get around the problem below, anyone have any ideas?
The following error message was returned from the SQL Server:
[7601] Cannot use a CONTAINS or FREETE...