Activity overview
Latest activity by SPeacock1978
I am having a similar problem. I have a table that has a full text index on it and there is a stored procedure that uses this functionality. When I use SQL Compare 10 to create a deployment script the scripts creates the objects in the following order:
1) Create table
2) Create indexes
3) Create stored proc
4) Create full text index on table
As the full text index does not exist at the time the stored proc is being created I get the following error...
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblCompany' because it is not full-text indexed.
Is there a way to control the ordering of the objects in the scripts or is it all automatic? / comments
I am having a similar problem. I have a table that has a full text index on it and there is a stored procedure that uses this functionality. When I use SQL Compare 10 to create a deployment script...