Reading SQL Script from Stored Procedure

#1

Hi Everybody,

Good day!

Are there any direct methods in dotnet for reading the SQL script from a database for a particular stored procedure!

Note:
I'm aware of using SP_HELPTEXT in a DataReader!

Thanks in advance.
--------------------------------
From: Prabhu Ram Prasath V

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>hXnY/BPuY0y6u4KsmXyPnQ==</Id>

#2

No. There are no methods from ADO.Net to do this.
--
HTH,
Sushil Chordia.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Prabhu Ram Prasath V via .NET 247" <anonymous (AT) dotnet247 (DOT) com> wrote in
message news:%23nxZfH%23kEHA.3520 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Quote:

Hi Everybody,

Good day!

Are there any direct methods in dotnet for reading the SQL script from a
database for a particular stored procedure!

Note:
I'm aware of using SP_HELPTEXT in a DataReader!

Thanks in advance.
--------------------------------
From: Prabhu Ram Prasath V

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

Id>hXnY/BPuY0y6u4KsmXyPnQ==</Id

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Reading SQL Script from Stored Procedure

Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet

Reading SQL Script from Stored Procedure - 09-06-2004 , 03:19 AM

Re: Reading SQL Script from Stored Procedure - 09-16-2004 , 01:59 PM