var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Using DATABASEPROERPTY you can get details on database
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.