Microsoft Search Service

Posted Date: 01 Aug 2008 Resource Type: Articles Category: Databases

Posted By: Kundan Kumar Sinha Member Level: Gold
Rating:

Points: 10

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.

Ex:


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

Populate the full-text catalog with full-text index information

Execute a full-text query against the new table

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Using Microsoft Search Service in SQL Server . Microsoft Search Service . Full-text search using Microsoft Search Service . Full-text search in SQL Server using Microsoft Search Service . Full-text search in Sql Server 2000 .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: T-SQL's New Features in SQL Server 2005
	Previous Resource: How to shuffle result sets in datagrid
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj