Originally posted by highlife
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!
Um... that's backwards... UDFs weren't implemented until SQL2000.... prior to that they aren't available.... (your statement seems to imply that in 6.5 they were there, but in 7 and 2K they aren't, which is incorrect).
What you need is the SQL DMO for SQL2000, and connect to a SQL2000 server.... if either of the components (DMO or the server itself), then you won't be able to get the UDFs.