Finding all current indexes in database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Tait - 22 Sep 2006 13:04 GMT

Is it possible to list all of the current Full Text Indexes on a given
database by using a command or statement through the query analyzer?

My problem is that i setup a full text index for a database 1 year ago
and have since forgotten its name and from what i can tell my
sql/vb.net doesnt make any reference to this index directly. Could a
work around be to just create a new index?

Thanks
David

Reply to this Message

Hilary Cotter - 23 Sep 2006 02:30 GMT

try sp_help_fulltext_tables

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Is it possible to list all of the current Full Text Indexes on a given
> database by using a command or statement through the query analyzer?
[quoted text clipped - 6 lines]
> Thanks
> David

Reply to this Message

David Tait - 23 Sep 2006 16:41 GMT

Thanks, it worked perfectly!

> sp_help_fulltext_tables

Reply to this Message