Posted by Raziq Shekha on 10/01/21 11:42

What is the procedure to create a full text index on a view? I created
full text indexes on the underlying tables for a view, but when the
query is run against the view I am getting the errror message:

Server: Msg 7601, Level 16, State 1, Line 1
Cannot use a CONTAINS or FREETEXT predicate on table
'dbo.apcgd_globaldir_master' because it is not full-text indexed.

If there is a document which outlines steps to create a full text index
on a view that would be great.

Thanks in advance.
Raziq.

*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]