Posted by Chris Fulstow on 04/09/06 19:44

Hi Serge,

As well as using SQLDMO, you could also query the built-in sysobjects
table to get the names of your UDFs, e.g.

SELECT [name] AS [UDF Name]
FROM sysobjects
WHERE xtype = 'FN' or xtype = 'IF'
ORDER BY [name]

FN = Scalar function
IF = In-lined table-function

HTH,

Chris

• Next in forum: Re: Disk or network error
• Prev in forum: Re: Re-display result set without re-running query in Query Analyzer?
• Thread view: Re: SQL-DMO and C#: retrieve the list of User-Defined Functions

[Reply to this message]