>I've got a function within a class which acts as middle tier between sql server and .net front-ends. Total of 165 parameters to be received from front-end and must be passed to sql server database (stored procedures). An error 'Too many arguments' occurs on the execution of the function.
>
>What is the max parameters that can be received and if less than 165 how can it be done otherwise?
>
>Thanks

Documented limit is 26 parameters, undocumented is more than that depending on how you pass them.

Any variable is counted as one parameter and a variable could be an array or object carrying multiple paramaters which makes the limit virtually endless. ie: You could pass a recordset object as a single parameter which carries thousands of rows and columns, or an XMLStream, XMLDOM etc.etc.
Cetin