Google
 

Thursday, February 5, 2009

Full Text Catalogs in SQL Server

Gathering status and detail information for all Full Text Catalogs for an instance of SQL Server


Problem
I have several Full Text Search enabled databases and these databases contain several catalogs. Very often, I deploy these databases to many servers, so I need to know if these are deployed correctly and also find out as quickly as possible. I need to know the population progress as well, but using management studio is too slow and also very hard to find out how much the catalogs have been populated.

Solution
You can use a T-SQL Script to pull all the major information at once. The query below has been tested and works on SQL 2000, SQL 2005 and SQL 2008.