From Books online:
A
The full-text search engine (Microsoft Search service) is installed by default with a typical installation of Microsoft® SQL Server™ 2000, Standard and Enterprise editions.
B
To create a full-text catalog Expand a server group, and then expand a server.
Expand Databases, and then right-click the database where you want the full-text catalog.
Click New, and then click New Full-Text Catalog.
Complete the New Full-Text Catalog dialog box. C
Identify the tables and columns that are to be registered for full-text search.
Index the data in the registered columns and populate full-text indexes with the nonextraneous words.
Issue queries against the registered columns for populated full-text indexes.
Ensure that subsequent changes to the data in registered columns get propagated to the index, thus keeping the full-text index synchronized with the data.
Examples:
Enabling Others to Issue Full-Text Queries---Books online
A
The full-text search engine (Microsoft Search service) is installed by default with a typical installation of Microsoft® SQL Server™ 2000, Standard and Enterprise editions.
B
To create a full-text catalog Expand a server group, and then expand a server.
Expand Databases, and then right-click the database where you want the full-text catalog.
Click New, and then click New Full-Text Catalog.
Complete the New Full-Text Catalog dialog box. C
Identify the tables and columns that are to be registered for full-text search.
Index the data in the registered columns and populate full-text indexes with the nonextraneous words.
Issue queries against the registered columns for populated full-text indexes.
Ensure that subsequent changes to the data in registered columns get propagated to the index, thus keeping the full-text index synchronized with the data.
Examples:
Enabling Others to Issue Full-Text Queries---Books online
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货