Microsoft? SQL Server? 2000 full-text query component supports complex search on string columns.
This feature is implemented by Microsoft Search Service, which has two functions:
Index support
Implement a full-text directory and index defined by the database. Accept the definition of tables and columns constituting indexes in each directory. Execute a request to fill a full-text index.
Query support
Handle the full text search query. Determine the item that satisfies the full text selection condition in the index. For each item that meets the selection conditions, it returns the MSSQLServer service
A plurality of equal levels, the MSSQLServer service will use this information to construct query results set. The supported query types include:
Retrieve words or phrases.
Search word similar.
Inflexible variation of verbs and nouns.
Full-text engine as Microsoft Windows NT? Server, Windows NT Advanced Server, Windows? 2000 Server or Windows
Microsoft Search Service on 2000 Advanced Server runs. The full-text engine is installed when the full-text retrieval function is selected during a custom installation.
The Microsoft Search Service itself is not installed during the SQL Server Desktop Engine installation process. Although this means Microsoft Windows 95,
Windows 98, Windows NT Workstation or Windows 2000 PROFESSIONAL client is not installed on the Microsoft search service, but these
The client can use the service when connecting to the Server 2000 Standard Edition, SQL Server 2000 programmer version or SQL Server 2000 Enterprise Edition
.
The full-text directory and index are not stored in the SQL Server database, but stored in a file that is managed separately by the Microsoft Search Services. In SQL Server
The full-text directory file is not restored during the recovery process. You cannot use Transact-SQL Backup and RESTORE statements to back up and restore them. Perform recovery or restore
After the operation, you must re-synchronize the full-text directory separately. Only Microsoft Search Services and Windows NT or Windows 2000 System Administrators can access
Wen catalog file.
Communication is implemented between SQL Server and Microsoft Search Services.
The full-text directory, index, and search supported by the Microsoft Search Service are only available for tables in the SQL Server database. Windows NT indexing service and
Windows 2000 Indexing Services is similar to those provided on the operating system file. Indexing services include OLE for indexing services for OLE DB users.
DB provider. The SQL Server application can access the OLE DB provider for indexing services via a distributed query. TRANSACT-SQL statement can
The full text search and file of the SQL Server table will be referenced by using a full-text SQL constructor and a distributed query reference for an OLE DB provider for indexing services.
The textual search of data is combined. For more information, see the full-text query for file data.
There is only one Microsoft search service on any computer running multiple SQL Server instances. A single instance of the full text search engine is the computer on the computer
There are SQL Server 2000 and SQL Server version 7.0 instance management full-text index.
