BUG: Text And Image Can Be Parameters for Stored Procedures

• Microsoft SQL Server, versions 6.0 and 6.5

      15643 (6.00)

SYMPTOMS

The documentation for SQL Server 6.0 and 6.5 incorrectly states that you cannot use either text or image parameters for stored procedures. The SQL Server "Transact-SQL Reference" has references to datatypes on pages 53, 118, and 176. The SQL Server "Database Developer's Companion" has references to datatypes on page 201. On all of these pages, the documentation incorrectly states that text and image datatypes cannot be used for parameters.

The image and text datatypes have been available for use as parameters in stored procedures since Microsoft SQL Server version 6.0. However, image and text datatypes still cannot be used as local variables.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft SQL Server version 6.0 and 6.5 documentation. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.