Created On:  03 September 2012

Problem:

When running the StarTeam 2009 R2 SQL Script “starteam_sqlserver_dbcc.sql” the following error message if displayed:

Msg: Executing the query "dbcc newalloc" failed with the following error:

"Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.".

Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Resolution:

This error occurs because of the following parameters, which have been deprecated by MS SQL:

dbcc newalloc
go 

The SQL script “starteam_sqlserver_dbcc.sql” has since been amended, removing the deprecated commands.

Incident #2574779