--- for mgmt only UPDATE dbo.TaskItSaveName SET TaskItProfileId = 8 --, -- CASE -- WHEN @order = 1 THEN X.FormatIdKey -- WHEN @order = 3 THEN X.FDATE -- END ASC, -- CASE -- WHEN @order = 2 THEN X.FormatIdKey -- WHEN @order = 4 THEN X.FDATE -- END DESC EXEC sp_fulltext_database 'enable' SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') Test fulltext select * from FormatFullText where contains(Data,'pop') SELECT * FROM FORMAT AS A INNER JOIN ( SELECT KEY_TBL.RANK AS Hits, FT_TBL.FormatIdKey FROM FormatFullText AS FT_TBL INNER JOIN FREETEXTTABLE(FormatFullText, (Folder,DisplayName,Data), 'Penguins') AS KEY_TBL ON FT_TBL.Id = KEY_TBL.[KEY] ) AS B ON B.FormatIdKey = A.FormatIDKey ORDER BY Hits DESC