title: SQL Error: "Cannot use full-text search in user instance."
body: <p>I'm using SSEUtil to automatically create a functional test database from the schema derived from my development database (SQL Server 2008 R2) as part of my build process. This allows me to keep the two databases in-sync (schema-wise) without running SQL repository tests against my development database.</p>
  
  <p>I recently added a full text index to a table for the first time for this project in my development schema and now when I attempt to apply the schema to a newly created unit test database I get the following error when it executes the SQL to create the full text catalog:</p>
  
  <pre><code>CREATE FULLTEXT CATALOG [FullTextCatalog] AUTHORIZATION [dbo]
  GO
  </code></pre>
  
  <blockquote>
    <p>Cannot use full-text search in user instance.<br>
    [SqlException Number 9982, Class 16, State 100, Line 1]</p>
  </blockquote>
  
  <p>I've searched high and low. The only help I found was on another site where someone suggested "attaching to the parent database." I have no idea what that means. And I have no idea what this error means. What is a "user instance"? </p>
  
  <p>Can anyone suggest a way around this? Is there a better way to keep two database schemas in-sync for continuous integration?</p>