Retrive a Store procedure definition (script) in C#?

[Brian]

I need to retrieve a store procedure definition of a
previously created procedure in SQL Server 2000 to
generate an alter store procedure script that I can run in
c# to update the procedure at runtime. Any ideas on how
to go about this?

 

[AlexS]

Start from checking Books online for MS SQL. You will need to extract
definition from system tables.

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

HTH
Alex