Knowledge Base

FIX: SET ANSI_WARNINGS ON Option Does Not Generate Warnings

Article ID: 159372

Article Last Modified on 2/22/2005

APPLIES TO

This article was previously published under Q159372
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: kbbug kbfix kbusage KB159372


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.