Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 950
  • Last Modified:

How to get list of Full Text Catalog in a Database or Server?

Hello,

How can I get a list of every Full Text catalog in a database or the server?
Is there a way to know Population for which Catalog is currently running?
0
mekusharim_ltd
Asked:
mekusharim_ltd
1 Solution
 
Eugene ZCommented:
<list of every Full Text catalog in a database or the server?

Obtain a list of all the full-text catalogs linked to your database by running this query:

 use YourDB

SELECT name
FROM sys.fulltext_catalogs;
GO
---
<Population for which Catalog is currently running?
SELECT FULLTEXTCATALOGPROPERTY('yourFTStalog', 'Populatestatus')
more:
http://msdn.microsoft.com/en-us/library/aa258893(SQL.80).aspx
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now