Gettings stored procedure source text? (1 Viewer)

[Kodo]

Getting stored procedure source text?

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.

 

[Uncle Gizmo]

Hi Kodo,
merry Christmas to you!

I have several MS SQL related links on my website, and I recall this one which may be of some help. One of the bulleted items is:

*View, create and edit stored procedures


Tony..

 

[Kodo]

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