Re: Finding all current indexes in database?
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Fri, 22 Sep 2006 21:30:57 -0400
try sp_help_fulltext_tables
--
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
"David Tait" <mrdtait@xxxxxxxxx> wrote in message
news:2006092213044516807-mrdtait@xxxxxxxxxxx
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
.
- Follow-Ups:
- Re: Finding all current indexes in database?
- From: David Tait
- Re: Finding all current indexes in database?
- References:
- Finding all current indexes in database?
- From: David Tait
- Finding all current indexes in database?
- Prev by Date: Re: FTS 2005 system exception c0000005 every few seconds
- Next by Date: Re: FTS 2005 system exception c0000005 every few seconds
- Previous by thread: Finding all current indexes in database?
- Next by thread: Re: Finding all current indexes in database?
- Index(es):
Relevant Pages
|
Loading
