Get Text from Stored Procedure or View

[bradwest1217]

Hello everyone. I need some help and I don't even know if it is possible. I want to connect to a SQL database and instead of running "exec sp_Whatever" or "Select * from vw_Whatever" I want to get the text of the stored procedure or view so I can modify it as needed then run it using vb.net. I just need the mechanism to get the text from the procedure or view. Ideas?

Thanks

Brad

 

[TechGnome]

sp_helptext put_your_stored_procedurename_here

-tg