FIX: SET ANSI_WARNINGS ON Option Does Not Generate Warnings

ID: Q159372

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 15720 (Windows 6.50)

SYMPTOMS

The SET ANSI_WARNINGS ON option does not cause an error if an INSERT or UPDATE statement violates the maximum specified field length of the column it is inserted into. For references on the maximum lengths of each datatype, refer to your documentation.

STATUS

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

Additional query words: ANSI


Keywords          : kbusage SSrvTran_SQL kbbug6.50 kbfix6.50.sp2 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 4, 1999