Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Korea
    Posts
    9

    Unanswered: How can I check whether a table in database has the FULLTEXT INDEX or not.

    Our production DBs are SQL Server 2000(Enterprise Edition) on Windows2003.
    Can anybody tell me how can I check whether a table has a FullText Index or not?

    Thank you!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Using DATABASEPROERPTY you can get details on database
    IsFulltextEnabled
    Database is full-text enabled.

    I'm not sure whether a table is enable for that, BOL refers


    To check the status, tables, and schedules of a full-text catalog
    1. Expand a server group, and then expand a server.
    2. Expand Databases, and then expand the database that contains the full-text catalog to review.
    3. Click Full-Text Catalogs, and then right-click the specific catalog to review.
    4. Click Properties, and then click the Status, Tables, and Schedules tabs, as appropriate.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •