Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a list of records contained within a MS SQL database table, we have enabled "Full Text Indexing" on the table. Also, we have set up a window's file indexing service and added a catalog containing *.doc, *.pdf, and *.xls files.

We have put the two pieces together by creating a search page that combines the results from the SQL DB and the indexing service. What we are trying to figure out is how to use the "rank" passed back from both methods to order the results.

Here is an example of the query used to retrieve the rank for full text:

select rank from freetexttable(table1, description, @SearchText)

Here is an example of the query used to retrieve the rank from the file indexing service:

select rank from Scope() where freetext(contents, @SearchText)

Has anyone tackled this problem before? Is there a way to correlate the rank from both methods.

share|improve this question

migrated from stackoverflow.com Aug 13 '12 at 21:12

This question came from our site for professional and enthusiast programmers.

Can you give us more details about how the file indexing thing works, and how it interacts with SQL Server? Your description is extremely vague. Also, which version of SQL Server are you using? –  Jon Seigel Aug 14 '12 at 3:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.