linq to sql - Can I set "Parameters per stored procedure" higher than 2100 in SQL Server 2005/08? -

There may be a single SQL statement that has a hard limit of the number of parameters, and that is 2100 (SQL Server 2005 For)), or 1024 (for SQL Server 2000).

Does anyone know a way to increase that number?

If you want to know "why" (as I used to do, my curiosity is dying), Ezner is in:

  MyL2SDataContext.Accounts.Where (Acct = & gt; selectedAccountIDs.Contains (acct.ID)) ...  

Thanks,

This is a difficult limit - and I seriously need a genuinely realization of that particular example in the light of the example code given by you.