Friday, August 1, 2008

SQL: retrieve store procedures definitions in SQL Server

select P.name, M.definition
from sys.sql_modules M
inner join sys.procedures P
on P.object_id = M.object_id
order by P.name

No comments: