SqlServer 2008 with Full-Text search

[timewaster]

I am using SqlServer 2008 with the Full-Text search.

After I insert a row into a table that is setup with full text search, i need to wait for some unspecified amount of time after the insert before my query will return the row i just inserted.

Why is this happening?
Is it possible to setup the insert to not finish until the full-text index on the row i just inserted is complete?

This some example code i am using:

INSERT INTO q_DocVersion_International ([f_Doc_ID] ,[f_Headline] ,[f_Synopsis] ,[f_HeadlineOrder])

VALUES (-990 ,'UPDATE 2-Dissident Chrysler lenders step up Languinxdy opposition' ,NULL ,NULL)

wait 1 sec, then i execute the query:

Select q_DocVersion_International.f_Doc_ID

From q_DocVersion_International

Where Contains(q_DocVersion_International.f_Headline, 'Languinxdy')

[George1111]

To guarantee availability of data immediately after an insert, I have found that you need to Close the Table, then Close the Database.

Closing just the table doesn't do it (immediately)

[adatapost]

Once Insert/Delete/Update query is executed; you must close the database connection not a database. And also close database connection immediately after select query get executed.