Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Maximum number of SP parameters?
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01096204
Message ID:
01096215
Views:
16
>>Is there a maximum number of parameters for a SP? If yes what is the maximum number? (I think I might have reached such number in one of my SP <s>)
>
>2,100. See Maximum Capacity Specifications in BOL.

Great then I am not exceeding it. I only have 303 parameters!. Thanks for the reply Sergey.

Update: I duplicated one of the parameters when I called the SP, but good to know that the max is 2100.

Einar
Semper ubi sub ubi.
Previous
Reply
Map
View

Click here to load this message in the networking platform