Wednesday, March 28, 2012

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!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
Expand a server group, and then expand a server.
Expand Databases, and then expand the database that contains the full-text catalog to review.
Click Full-Text Catalogs, and then right-click the specific catalog to review.
Click Properties, and then click the Status, Tables, and Schedules tabs, as appropriate.sql

No comments:

Post a Comment