title: System Views text in SQL Server 2005
body: <p>I am looking for viewing the text of the system views and procedures in SQL Server 2005 using the object explorer or using sp_helptext.</p>
  
  <p>actually i am coming from the SQL Server 2000 background, where we have the feature of retreiving the code of the view and the stored procedure using SQL Server 2000 Enterprise manager directly, but still i am unable to find this feature in the SQL Server 2005 Management Studio and still looking for the same feature for getting the view and procedure text in SQL Server 2005.</p>
  
  <p>Kindly please help me in this.</p>