Microsoft KB Archive/812914

= BUG: DBCC CHECKCONSTRAINTS Fails with Error Message 170 =

Article ID: 812914

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



BUG #: 363951 (SHILOH_BUGS)



SYMPTOMS
The DBCC CHECKCONSTRAINTS command fails, and you receive the following error message when the CONCAT_NULL_YIELDS_NULL option is set off:

Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ')'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.



WORKAROUND
To work around the problem, follow these steps:   Explicitly set the CONCAT_NULL_YIELDS_NULL option on before you run the DBCC CHECKCONSTRAINTS command. For example: set CONCAT_NULL_YIELDS_NULL on go DBCC CHECKCONSTRAINTS  If you run DBCC CHECKCONSTRAINTS in Query Analyzer, in the Current connection properties dialog box, select Set concat_null_yields_null.



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000.

Keywords: kbbug kbsqlprog kbappdev kbquery KB812914

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.