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.
