Kodo "The Shoe" Local time Today, 06:33 Joined Jan 20, 2004 Messages 701 Dec 29, 2005 #1 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. Last edited: Dec 29, 2005
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.
Kodo "The Shoe" Local time Today, 06:33 Joined Jan 20, 2004 Messages 701 Dec 29, 2005 #2 ok, got that one sorted by using exec sp_helptext 'sprocname'
