Its working now.

We had to change one of the UDFs, there was redundant code. I can't believe it has been running in on SQL 2000 for years without any problems.

Thanks,...

Yes, the compatible level set to 90. I have done,

EXEC sp_dbcmptlevel MyDatabase , 90;

But, still no luck

Thx

Chandi