title: SQL 2008: Turn off Stop Words for Full Text Search Query
body: <p>I'm having quite a bit of difficulty finding a good solution for this:</p>
  
  <p>Let's say I have a table of "Company", with a column called "Name". I have a full-text catalog on this column. If a user searched for "Very Good Company", my query would be:</p>
  
  <pre><code>SELECT
      *
  FROM
      Company
  WHERE
      CONTAINS(Name, '"Very" AND "Good" AND "Company"')
  </code></pre>
  
  <p>The problem is in this example, the word "Very" shows up in the standard list of stopwords:</p>
  
  <pre><code>SELECT
      ssw.*
  FROM
      sys.fulltext_system_stopwords ssw
  WHERE
      ssw.language_id = 1033;
  </code></pre>
  
  <p>Resulting in the query returning with no rows, even though there is a row with the name "Very Good Company".</p>
  
  <p>My question is, how would I go about turning the stopwords off for my query? Or how would I go about removing them entirely?</p>
  
  <p>Or is there another way I should be going about this search?</p>