Post reply

SQL Server 2000 full-text index status

  • July 5, 2010 at 7:47 pm

    #99340

    With databases in SQL Server 2000, I can see if full-text index status is active or inactive. All I have to do is right click a table, go to Properties, and click on the the Full-Text Indexing tab. The problem is that I have about 30 databases -- many of which have over one thousand tables. Is there a query that I can run to show which tables have "full-text index status" active or inactive?

  • July 5, 2010 at 9:34 pm

    #1188917

    Have you looked at the sp_help_fulltext_catalogs procedure .. you could couple that with the undocumented sp_msforeachtable and that may give you some assistance

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply