Microsoft KB Archive/106132

FIX: CREATE TABLE Does Not Generate Warning Message

PSS ID Number: Q106132 Article last modified on 12-02-1994

4.20

WINDOWS

The information in this article applies to:

- Microsoft SQL Server version 4.2

BUG# NT: 545 (4.2)

SYMPTOMS

In the “Transact-SQL Language Reference” for Windows NT (page 241), it states under CREATE TABLE:

The maximum number of bytes per row is 1962. If you create tables with varchar or varbinary columns whose total defined width exceeds 1962 characters, a warning message appears, although the table is created…

The table is properly created, but SQL Server fails to post the warning message.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. This problem was corrected in SQL Server version 4.21a. For more information, contact your primary support provider.

Additional reference words: 4.20 transact-SQL Windows NT KBCategory: kbother KBSubcategory: SSrvWinNT

=================================================================

Copyright Microsoft Corporation 1994.