Hi Marc will you please give example for your sys.sqlmodules I am using SQL 2008 R2 & failed to find sys.sqlmodules or way to execute it to retrieve stored procedure text...

in SQL 2008 R2 - Go to Tools - Options left hand side Query Results - SQL Server - Result to Grid select 2nd check box to the right - Include Column Headers when copying or saving the results this will always copy grid data with headers. Rega...

in SQL 2008 R2 - Go to Tools - Options left hand side Query Results - SQL Server - Result to Grid select 2nd check box to the right - Include Column Headers when copying or saving the results this will always copy grid data with headers. Rega...