Sql Server

SQL Server 2008 features quite a number of changes and improvements in full-text searching:
A dedicated indexing service that works directly with SQL Serrver. This speeds up full-text operations and isolates SQL Server from changes to the search service made by other applications.

Data definition language (DDL) statements for creating and altering full-text catalogs and indexes.

Full-text queries against linked servers.

Full-text queries against arbitrary sets of columns (instead of just one column or all columns).

Specification of the language to be used for word-breaking in an index. Integrated backup and restore for full-text catalogs.

Full-text indexing for XML data.

Integration with SQL Profiler and logging of index operations.

If you were interested in full-text searching in SQL Server 2000 but ran into brick walls, take another look when the new version comes out. Microsoft's substantial work in this area means that full-text indexing and searching will be better than ever.