jpatevans4651 (12/24/2008)
Hi,Is there no limit to stored procedure parameters because when I use ado.net I get the following when trying to call a stored procedure with 12 parameters:
Procedure or function GetItem has too many arguments specified.
I know this isn't a .net board but figured others may have run into this.
thanks.
There is a limit, I don't recall what it is off the top of my head, but it's available in Books Online. It's something like 256 I think, so 12 is not it.
That error means the procedure had 11, or less, parameters and you passed it too many.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning