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 as database_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.


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s