Category Archives: SQL Server

Full-Text Search with SQL Server 2008

The full-text search capabilities of SQL Server 2008 make it possible to search text across multiple columns, weight search terms, and search by proximity. A full-text query can be much faster than the equivalent LIKE query. The first step is … Continue reading

Posted in SQL, SQL Server | Leave a comment

Checking if FullText Service is installed on SQL Server 2008

SELECT FullTextServiceProperty(‘IsFullTextInstalled’) This will return 1 if the service is installed.

Posted in SQL Server | Leave a comment