title: sql server invalid object name - but tables are listed in SSMS tables list
body: <p>I am attempting to create a <code>Stored Procedure</code> for a newly created database. However the <code>SSMS</code> intellisense does not recognize more than half of the tables which have been created. </p>
  
  <p>For example whilst in the left hand column under tables I have a table <code>dbo.Room</code>, when I type "<code>dbo.</code>" in the new query window, that table is not listed, in fact only 17 out of 37 tables are listed. </p>
  
  <p>I can see no difference between the tables listed by intellisense and those not. If I manually type dbo.Room, it is underlined, with an error of </p>
  
  <blockquote>
    <p>Invalid Object Name 'dbo.Room'..</p>
  </blockquote>
  
  <p>Have I missed something in setting up the tables? </p>
  
  <p>UPDATE: I have tried refresh of the tables list (several times)</p>