Kodo "The Shoe" Local time , 23:23 Joined Jan 20, 2004 Messages 707 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.
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 04:23 Joined Jul 9, 2003 Messages 17,444 Dec 29, 2005 #2 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.. Last edited: Dec 29, 2005
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 "The Shoe" Local time , 23:23 Joined Jan 20, 2004 Messages 707 Dec 29, 2005 #3 ok, got that one sorted by using exec sp_helptext 'sprocname'