title: SQL Server - Return SCHEMA for sysobjects
body: <p>How to I get the SCHEMA when doing a select on sysobjects?</p>
  
  <p>I am modifing a stored procedure called <strong>SearchObjectsForText</strong> which returns only the Name but I would also like to include the SCHEMA. </p>
  
  <p>Right now it is doing something similar to this:</p>
  
  <pre><code>SELECT DISTINCT name
  FROM sysobjects
  </code></pre>
  
  <p>I would like to know what tables need to be joined to return the SCHEME for each 'name'.</p>