I use a lot of User Defined Functions in SQL Server 2000, and sometimes I get this error. It is a known bug. There is a hotfix at http://support.microsoft.com/default.aspx?scid=kb;en-us;834688
If it is not feasible to apply the hotfix, have a look here for a solution that works some of the time: http://support.microsoft.com/default.aspx?scid=kb;en-us;819264
posted on Tuesday, October 05, 2004 8:28 PM