title: CREATE FULLTEXT INDEX/CATALOG statement cannot be used inside a user transaction
body: <p>I have a db versioning app to update deployed databases. It runs smoothly with almost all SQL statements but when I decided to use FullText Search  and generated scripts to use statements like following it broke.</p>
  
  <pre><code>CREATE FULLTEXT CATALOG [ProductCatalog]
  
  --Create fulltext index on Product
  CREATE FULLTEXT INDEX ON [tblProduct] KEY INDEX [PK_Catalog]
      ON ([ProductCatalog]) WITH (CHANGE_TRACKING AUTO)
  ALTER FULLTEXT INDEX ON [tblProduct] ADD ([ProductName] LANGUAGE [English])
  ALTER FULLTEXT INDEX ON [tblProduct] ENABLE
  </code></pre>
  
  <p>I use the following code to execute SQL file within a C# SqlTransaction</p>
  
  <pre><code>SqlConnection cnn = new SqlConnection("cstring");
  SqlTransaction trn = cnn.BeginTransaction();
  
  cnn.Open();
  
  using (SqlCommand cmd = cnn.CreateCommand())
  {
      cmd.Connection = cnn;       
      cmd.Transaction = trn;
  
      cmd.CommandText = SQLScript;
      cmd.CommandType = CommandType.Text;
      cmd.ExecuteNonQuery();
  }
  
  trn.Commit();        
  cnn.Close();
  </code></pre>
  
  <p>How can I run my scripts without a transaction?</p>