I'm trying to install a DB that was originnaly on SQL Server 2000 to MSDE. Everything goes fine execpt for user defined functions.

In Enterprise Manager for the new MSDE DB, there is no UDF node. I've tried firing a CREATE FUNCTION, with no success.

I've looked at Microsoft's white paper on MSDE and there is mentions about several limitations downgrading to MSDE, but I could not find anything related to UDF .

Any inputs would be appreciated.