Share via

how can increase the maximum parameters in sql server

Siddhrajsinh Rathod 0 Reputation points
2023-08-17T06:36:39.89+00:00

how can increase the maximum parameters in sql server

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 120.2K Reputation points MVP
    2023-08-17T22:08:42.8166667+00:00

    You mean the maximum numbers of parameters to a stored procedure, which is 2100?

    You can file a suggestion on https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0. I recommend that you include a strong business case why 2100 is not enough.

    But most likely if think you need that many parameters, you are doing something wrong.

    1 person found this answer helpful.
    0 comments
  2. PercyTang-MSFT 12,511 Reputation points Microsoft External Staff
    2023-08-18T03:09:29.19+00:00

    Hi @Siddhrajsinh Rathod

    Which is the maximum parameters you mean?

    https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

    These capacity specifications are system-specific and difficult to change.

    Best regards,

    Percy Tang

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.