Programmatically Extract Stored Procedures

[Joe Gerstl]

Can anyone tell me how to programmatically extract stored procedures (like
SQL Enterprise Manager's Generate SQL Scripts function)?

[learndbms learndbms]

"Joe Gerstl" <joeg@mountainsystems.com> wrote:
>
>Can anyone tell me how to programmatically extract stored procedures (like
>SQL Enterprise Manager's Generate SQL Scripts function)?
>

Using sp_helptext storedprocedurename you will get the sptext, may be you
can try to save the result in an HTML using sp_makewebtask stored procedure.
may be this will give you a start.

[Neil Pike]

Joe - use the DMO api

> Can anyone tell me how to programmatically extract stored procedures (like
> SQL Enterprise Manager's Generate SQL Scripts function)?
>

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
or www.ntfaq.com/sql.html
or www.sql-server.co.uk
or www.mssqlserver.com/faq

[Joe Gerstl]

Both great suggestions. Thanks!

Neil Pike <neilpike@compuserve.com> wrote:
>Joe - use the DMO api
>
>> Can anyone tell me how to programmatically extract stored procedures (like
>> SQL Enterprise Manager's Generate SQL Scripts function)?
>>
>
> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please reply only to newsgroups)
> SQL FAQ (428 entries) see
> forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip
- L7
>- SQL Public)
> or www.ntfaq.com/sql.html
> or www.sql-server.co.uk
> or www.mssqlserver.com/faq
>
>