List all full-text search catalogues on an instance

With the following script you can easily find all FTS catalogues and their state on the SQL Server instance.

  1. select sd.name as database_name,fts.name as fts_name,fts.catalog_id,
  2.        fts.is_importing,fts.is_paused,fts.status_description
  3. from sys.dm_fts_active_catalogs fts
  4. inner join sys.databases sd
  5.       on fts.database_id = sd.database_id

This could come handy when you are migrating a database as you should take care of rebuilding all FTS catalogues and for that – you will need a list of what should be rebuilt.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s