title: Database project deployment
body: <p>I have database project in visual studio 2010. It has tables views stored procedures etc. I have created a full text index on view and in stored procedure I am using like this:</p>
  
  <pre><code>create proc myproc
  
  as
  
  select * from my view 
  where contains(tblperson.fname,'Steve')
  
  end
  </code></pre>
  
  <p>When I deploy, I get error that I can't use contains as view is not full text indexed. I want to know if there is a sequence in which database project is deployed ? means first stored proc is deployed or views are deployed. Can I change this sequence.</p>
  
  <p>Please suggest.</p>