too many parameters were provided in this rpc request. the maximum is 2100 when less than 2100 parameters exist in query

Asked Oct 07 '14 at 22:46

Active Oct 07 '14 at 22:46

Viewed 287 times

I'm receiving the TDS RPC error that the rpc request exceeds 2100 parameters on a stored procedure call. However, i'm only showing 2042 parameters in the query when I run the SQL Profiler and I'm able to run the stored procedure with the query from the profiler without issue. However, the web application is still throwing that error.

Is the actual limit less than 2100 or are there different variables that count towards the parameter limit?

asked Oct 07 '14 at 22:46

AutomationEngineer1982

Holy smokes, that's a lot of parameters! – 500 - Internal Server Error Oct 07 '14 at 22:48
yeah it's due to a linq query with contains() and it parses out each of the objects. I don't have access to modify the code so I was hoping there was some other method to clear this up. – AutomationEngineer1982 Oct 07 '14 at 22:49
Couple of linq solutions here: http://stackoverflow.com/questions/1028547/too-many-parameters-were-provided-in-this-rpc-request-the-maximum-is-2100 – Rich Ard Oct 08 '14 at 00:20

too many parameters were provided in this rpc request. the maximum is 2100 when less than 2100 parameters exist in query

0 Answers0