Check if record is full-text indexed

[Pacific Fox]

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..

[Jack Vamvas]

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" <ta*******@gmail.comwrote in message
news:11**********************@l77g2000hsb.googlegr oups.com...

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..