Microsoft SQL Server 2000

SQL Server 2000 is a family of products that meets the data storage and analysis requirements of the largest data processing systems and commercial Web sites. SQL Server 2000 can provide easy-to-use data storage and analysis services to an individual or a small business.

Full-text search in SQL 2000 focuses on searching data that is primarily structured, but also includes textual, unstructured information.

SQL Server 2000 uses the same search engine technology used by SharePoint Portal Server, benefits from the same advanced ranking algorithm, and uses a subset of the full-text extensions to SQL used by SharePoint Portal Server. The following list describes the components of SQL Server.

• Data access. You can use full-text search in SQL server only over content stored in SQL columns.
• Filters. SQL Server 2000 uses filters installed on the server to handle documents stored in database columns. Users use IMAGE-type columns to store documents, and then specify a second column to indicate the document type. Full-text search then applies the appropriate filter, such as HTML, Office, or third-party filters, based on the document type. In addition, you can apply full-text search to the contents of columns of type [N]CHAR, [N]VARCHAR, and [N]TEXT.
• Extensibility and programmability. Full-text search SQL extensions are integrated into the T-SQL language. Users can specify SQL queries that span structured data from SQL tables, unstructured data from SQL columns, from documents embedded in the columns, and from the file system.

SQL Server 7 first introduced full-text search as a feature of SQL Server.