User define function

I am using SQL 2000, and have a database was updated all the way from 6.5. I can not create function on this database instance, but I can create function on any other "new" database instance. I think this is because this particular db was from 6.5 which do not support user define function.
Is there easy way to fix this problem or do I have to create new database and copy everything from the old one?
Thank you in advance.

[433 byte] By [WeiMing] at [2008-2-20]

«« MdiChild ControlBox still visible even when set to false ?
»» Programatically build a reference on a ASPX page using VB

# 1

What is the database compatibility level for the upgraded database? If it's still 6.5, then try changing it to 8.0.

GregYvkoff at 2007-9-9 >