Attaching and Detaching a Database

When I attach the Northwind database (using sp_attach_db) to SQL Server 2005, it succeeds. but when i run this request

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]

      

he gives me this error

"You cannot use the CONTAINS or FREETEXT predicate in a table or indexed Category view because it is not fully indexed."

What would be the possible solution? Do I need to create a FullText index?

please help me in advance

0


a source to share


1 answer


Yes, a full text index must be defined on the table to use CONTAINSTABLE.



+2


a source







All Articles