BUG: DBCC CHECKCONSTRAINTS Fails with Error Message 170 (812914)

The information in this article applies to:

Microsoft SQL Server 2000 (all editions)

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.

Modification Type:	Major	Last Reviewed:	10/3/2003
Keywords:	kbSQLProg kbQuery kbAppDev kbBug KB812914 kbAudDeveloper