title: Cannot view stored procedure body in Visual Studio
body: <p>Using Server Explorer in Visual Studio 2010 to browse and query a SQL Server - there are some stored procedures for the database but I could not find a way to view the body of the stored procedure in Visual Studio.</p>
  
  <p>From <a href="http://msdn.microsoft.com/en-us/library/ms345443.aspx" rel="nofollow">this MSDN article</a> I tried a few hints, but I kept getting:</p>
  
  <blockquote>
    <p>The EXEC SQL construct or statement is not supported</p>
  </blockquote>
  
  <p>Is there no way to do this from Visual Studio? I eventually solved my problem by installing SQL Management Studio; but I am hoping there is a way to do this in Visual Studio.</p>
  
  <p>Update:</p>
  
  <ul>
  <li>I am not using a project - that is, I am not in an active project in Visual Studio; it is a simple case of browsing the database's objects and executing some queries from the Server Explorer window.</li>
  <li>The database server appears in the Server Explorer tree as <code>SQLEDB.SERVER-NAME.DBNAME</code></li>
  <li>Visual Studio 2010 already has SP1 applied</li>
  <li>The same credentials allow me to view the body of the stored procedure when I connect via SQL Management Studio.</li>
  <li>SQL Server version is <code>SQL Server 8.0.2055 (8.0 SP4)</code></li>
  <li>Workstation is running Windows XP Professional (so <a href="http://msdn.microsoft.com/en-us/data/tools.aspx" rel="nofollow">SQL Server Data Tools</a> cannot be installed)</li>
  </ul>