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
Showing posts with label index. Show all posts
Showing posts with label index. Show all posts
Wednesday, March 28, 2012
Subscribe to:
Comments (Atom)