I have run into this issue on numerous occasions. We have functions that call themselves recursively. If you add a parameter to the function that calls itself, simply doing an alter function will not work because it will give you an error that "the procedure or function has too many arguments specified".
If you drop and create the function, it will create it properly.
Comments
If you drop and create the function, it will create it properly.
More details here:
http://www.red-gate.com/MessageBoard/vi ... hp?t=14113
Please give it a go and let us know if this meets your requirements.
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software
More details here:
http://www.red-gate.com/MessageBoard/vi ... hp?t=14113
Please give it a go and let us know if this meets your requirements.
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software