title: How to run stored procedure if it's in a separate schema
body: <p>I am using SQL Server 2008 R2, and I have created a schema <code>Test</code> and in that schema, I created a stored procedure.</p>
  
  <p>I wanted to run it in the text mode by issuing this query:</p>
  
  <pre><code>EXEC SP_HELPTEXT SCHEMA.SPROC
  </code></pre>
  
  <p>But while running the above query I get this error:</p>
  
  <blockquote>
    <p>Incorrect syntax near '.'.</p>
  </blockquote>
  
  <p>Can someone please help me here to resolve this issue.</p>