Comments
Sort by recent activity
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-...