Source of Views and SPs in SQL Server

[kishore_mala]

Hi,

I have a small problem. I would like to get the source of views and stored procedures in my SQL Server 7 database right from VB. Is it possible? I know that in query analyzer by issuing the command sp_helptext, I will get the source. But how from VB? Any help is very much appreciated.

Thanks in advance

Kishore

[Cakkie]

Well, you can call sp_helptext from vb through an open database connection to the server.
Another place where you can get this data is in the system table syscomments, wich holds the command text used to cretae the stored procedure/view. To get that, you will probably need to do a select on sysobjects first, to get the objectid of the object you are interested in.

[kishore_mala]

Hi,

Thank u very much. It solved my problem

Kishore