Created On:  03 September 2012


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.


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

dbcc newalloc

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

Incident #2574779