Maximum number of SP parameters? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Maximum number of SP parameters?

Message

From

14/02/2006 11:38:59

Sergey Berezniker
New York, United States

To

14/02/2006 11:30:14

Einar Kvandahl
Alliance Laundry Systems
Ripon, Wisconsin, United States

General information

Forum:

Microsoft SQL Server

Category:

Stored procedures, Triggers, UDFs

Title:

Re: Maximum number of SP parameters?

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01096204

Message ID:

01096208

Views:

23

This message has been marked as the solution to the initial question of the thread.

>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.

--sb--

Click here to load this message in the networking platform