title: Finding stored procedure in SQL Server 2008 Management Studio
body: <p>I'm new to Windows servers and I have a hopefully quick question. I am looking for a stored procedure in SQL Server 2008 Management Studio. I ran this query,</p>
  
  <pre><code>SELECT name, type
  FROM dbo.sysobjects
  WHERE (type = 'P')
  </code></pre>
  
  <p>Which returns a list of stored procedures. The one I am looking for is in the list. Now I need to know how/where to find this. I am browsing the structure on the left side and I see several folders of "Stored Procedures" but I do not see the item I am looking for in any of the lists. Is there SQL to show me the stored procedure or do I need to open it in SQL Server Management Studio? Could it also be a permission issue with the user I am connecting with?</p>
  
  <p>Thanks for any help on this. </p>