title: Full text search installed or not
body: <p>I have instaled SQL server 2008 R2 and when I run this SQL in SQL server management studio:</p>
  
  <pre><code>SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')
  </code></pre>
  
  <p>I get 0</p>
  
  <p>But If I run this:</p>
  
  <pre><code>SELECT * FROM sys.fulltext_catalogs
  </code></pre>
  
  <p>I get one row. I want to know If fulltext search is installed on my sql server or do I need to reinstall SQL server with advance options.</p>
  
  <p>Please suggest.</p>