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
Wednesday, March 28, 2012
How can I check whether a table in database has the FULLTEXT INDEX or not. -
Labels:
database,
dbs,
edition,
enterprise,
fulltext,
index,
microsoft,
mysql,
oracle,
production,
server,
sql,
table,
windows2003
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment