2008-06-30

SQL Server 2000 vs Recursive Functions

In SQL Server 2000, if you attempt to alter an existing recursive function so as to change the number of parameters, you will receive an error message complaining that you are passing the wrong number of arguments to the function.  This appears to be because SQL Server is checking against the old definition of the function being defined.