Microsoft KB Archive/106132

From BetaArchive Wiki

FIX: CREATE TABLE Does Not Generate Warning Message

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



The information in this article applies to:
- Microsoft SQL Server version 4.2

BUG# NT: 545 (4.2)


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.


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.