I’m working on overhauling a large project management application for a client that I inherited from a previous developer. Part of the application will produce various reports based on data pulled from a SQL Server database. The query that pulls this data is a Stored Procedure in the database. Rather than try to reverse engineer the SQL query, I can simply run a SQL query of my own to dump the SQL code from the Stored Procedure so I can incorporate it into my application.
Just log into SQL Server Management Studio, open the database where the Stored Procedure resides, and execute the following query: