Microsoft Search Service

Microsoft Search Service maintains and performs full-text searching. It is used to index, catalog and query information. It runs as a separate background service that enables SQL Server 2000 and other programs to process full text data request.

A full-text search using Microsoft Search service enables you to query character-based data in table. This means that most often a full-text query searches for particular words or phrases in character based columns.

Microsoft Search service perform a linguistic search of character data in table.


Select FieldName From TableName Where CONTAINS(FieldName, 'Text to be Searched')

Select FieldName From TableName Where FREETEXT(FieldName, '"Some portion of text to be Searched"')

Microsoft Search service uses structures outside of SQL Server 2000 to store information about full-text data. The two structures are full-text index and full-text catalog.

TO enable a full-text search
  • Create and populate a table in a database
  • Enable the database for full-text search
  • Create a full-text catalog
  • Register the table and columns for full-text search
  • Populate the full-text catalog with full-text index information
  • Execute a full-text query against the new table

  • Comments

    No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: