I need to get the actual text of a SQL Server 2000 user defined function from a VB6 program, given the functions name.

I am using the SQL-DMO object elsewhere in my program but for some reason the "UserDefinedFunctions" collection is no longer used in SQL Server 7 and later.

I can get the names of the functions from the sysobjects table of the database, but how can I actually get the text?

There has to be some sort of system stored proc or some VB library to get access to this.

Can anyone help?

thank you!