title: Attach and detach database
body: <p>When i attach a Northwind database(using sp_attach_db) to SQL server 2005 ,it finished successfully. but when i run this query </p>
  
  <pre><code>SELECT FT_TBL.Description, 
     FT_TBL.CategoryName, 
     KEY_TBL.RANK
  FROM Categories AS FT_TBL INNER JOIN
     CONTAINSTABLE (Categories, Description, 
        '("sweet and savory" NEAR sauces) OR
        ("sweet and savory" NEAR candies)'
        , 10
     ) AS KEY_TBL
     ON FT_TBL.CategoryID = KEY_TBL.[KEY]
  </code></pre>
  
  <p>it is giving me this error</p>
  
  <p>"Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Categories' because it is not full-text indexed."</p>
  
  <p>what will be the possible solution? Do we Need to create a Full -Text index?</p>
  
  <p>please help me thanks in advance</p>