Check if record is full-text indexed

#1

Hi all,

I am dealing with a very large database, and as soon as a record is
submitted I need to run a full-text query against it. I believe it
might take a while before the record is fully indexed and therefore
would not return a result.

How can I check whether the record in question is already indexed, if
at all?

This is MS SQL 2005

Thanks in advance..

#2

what sort of update mechanism are you using to update the Full text index
?for example, change tracking

--

Jack Vamvas
___________________________________
Need an IT job? <a href="http://www.itjobfeed.com">uk it jobs</a>

"Pacific Fox" <tacofleur (AT) gmail (DOT) com> wrote

Quote:

Hi all,

I am dealing with a very large database, and as soon as a record is
submitted I need to run a full-text query against it. I believe it
might take a while before the record is fully indexed and therefore
would not return a result.

How can I check whether the record in question is already indexed, if
at all?

This is MS SQL 2005

Thanks in advance..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Check if record is full-text indexed

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Check if record is full-text indexed - 04-20-2007 , 01:06 AM

Re: Check if record is full-text indexed - 04-24-2007 , 09:56 AM