Microsoft KB Archive/106132

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.