title: How can I know when SQL Full Text Index Population is finished?
body: <p>We are writing unit tests for our ASP.NET application that run against a test SQL Server database. 
  That is, the ClassInitialize method creates a new database with test data, and the ClassCleanup deletes the database. We do this by running .bat scripts from code.</p>
  
  <p>The classes under test are given a connection string that connects to the unit test database rather than a production database.</p>
  
  <p>Our problem is, that the database contains a full text index, which needs to be fully populated with the test data in order for our tests to run as expected.</p>
  
  <p>As far as I can tell, the fulltext index is always populated in the background. I would like to be able to either:</p>
  
  <ol>
  <li>Create the full text index, fully populated, with a synchronous (transact-SQL?) statement, or</li>
  <li>Find out when the fulltext population is finished, is there a callback option, or can I ask repeatedly?</li>
  </ol>
  
  <p>My current solution is to force a delay at the end the class initialize method - 5 seconds seems to work - because I can't find anything in the documentation.</p>