title: Could not find stored procedure, however can execute it
body: <p>I am new to SQL Server and created my very first stored procedure. It executes fine and I can locate it under 'Programmability', 'Stored Procedures' so I pop open a new query and type in the following statements:</p>
  
  <pre><code>use name_of_database
  exec name_of_stored_procedure 'value'
  </code></pre>
  
  <p>However before executing the stored procedure, the name of the stored procedure is underlined in red noting it cannot be found, so I run the query:</p>
  
  <pre><code>select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME = 'name_of_stored_procedure'
  </code></pre>
  
  <p>Nada. It returns nothing.</p>
  
  <p>However if I go ahead and execute the stored procedure, it works fine.</p>
  
  <p>What am I doing wrong?</p>