Check if record is full-text indexed

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..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://links.10026.com/?link=http://www.itjobfeed.com">uk it jobs</a>

"Pacific Fox" <tacofleur@.gmail.comwrote in message
news:1177049160.189956.209000@.l77g2000hsb.googlegr oups.com...

Quote:

Originally Posted by

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

sql