getting scripts from sql server 2000

I'm interested in writing a program that makes craete scripts for all
views and stores procedures in a sql server 2000 database, like the
ones you can get them from the Query Analyzer.
Can I retrieve these create scripts using some SQL statement? Or do I
have to use some special MS SQL Server API?
Use SQL-DMO Objects Library
<delta.jentry@.gmail.com> wrote in message
news:1140506452.304401.85450@.g14g2000cwa.googlegro ups.com...
> I'm interested in writing a program that makes craete scripts for all
> views and stores procedures in a sql server 2000 database, like the
> ones you can get them from the Query Analyzer.
> Can I retrieve these create scripts using some SQL statement? Or do I
> have to use some special MS SQL Server API?
>
|||Hi
There are also scripting options in Enterprise Manager.
John
"delta.jentry@.gmail.com" wrote:

> I'm interested in writing a program that makes craete scripts for all
> views and stores procedures in a sql server 2000 database, like the
> ones you can get them from the Query Analyzer.
> Can I retrieve these create scripts using some SQL statement? Or do I
> have to use some special MS SQL Server API?
>