Hello,
I was wondering if anyone knew how to obtain the source text (i.e Select x from table) of a stored procedure using any SQL server commands or functions..

Thanks.

Hi Kodo,
merry Christmas to you!

I have several MS SQL related links on my website (http://www.tonyhine.co.uk/tips.htm), and I recall this one (http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en) which may be of some help. One of the bulleted items is:

*View, create and edit stored procedures


Tony..

ok, got that one sorted by using exec sp_helptext 'sprocname'