title: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view
body: <p>I am trying to modify a stored procedure ( adding a new column in select statement) but I am getting this error:</p>
  
  <pre><code>Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'vwPersonSearch' because it is not full-text indexed.
  </code></pre>
  
  <p>When I try to create a Full text index on view 'vwPersonSearch' using SQL server 2008 R 2 management studio, I am getting this error:</p>
  
  <p>A unique column must be defined on this table/view.</p>
  
  <p>Please suggest solution to it</p>