1
Vote

Issue with full-text catalog and extended property

description

Full-text catalog ['AW2008FullTextCatalog'] and Extended Property ['AdventureWorks 2012 Sample OLTP Database' ] from AdventureWorks 2012 are not scripted out by DBSourceTools Due to the missing full-text catalog the SP 'uspSearchCandidateResumes' was not able to create.

Here is the error message:

Msg 7601, Level 16, State 2, Server PSL, Procedure uspSearchCandidateResumes, Line 27
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'HumanResources.JobCandidate' because it is not full-text indexed.

comments