BUG: Maximum Number of Parameters Per Stored Procedure (275858)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q275858
BUG #: 202850 (SHILOH)

SYMPTOMS

The "Maximum Capacity Specifications" section of Microsoft SQL Server 2000 Books Online incorrectly states that 1,024 parameters are allowed per procedure. The Transact-SQL CREATE PROCEDURE topic correctly states that 2,100 parameters are allowed.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB275858