SQL Server Errors or Failures Error: 2591 to Error: 2710



Error: 2591, Severity: 16, Cannot find a row in the system catalog with the index ID %d for table “%.*ls”.,
Error: 2592, Severity: 10, Repair: The %ls index successfully rebuilt for the object “%.*ls” in database “%.*ls”.,
Error: 2593, Severity: 10, There are %I64d rows in %I64d pages for object “%.*ls”.,
Error: 2594, Severity: 10, Cannot process rowset ID %I64d of object “%.*ls” (ID %d), index “%.*ls” (ID %d), because it resides on filegroup “%.*ls” (ID %d), which was not checked.,
Error: 2596, Severity: 16, The repair statement was not processed. The database cannot be in read-only mode.,

Error: 2597, Severity: 10, Ignoring trace flag %d. It is either an invalid trace flag or a trace flag that can only be specified during server startup.,
Error: 2598, Severity: 16, Check cannot proceed on any objects belonging to database “%.*ls” because it is currently in recovery.,
Error: 2599, Severity: 16, Cannot switch to in row text in table “%.*ls”.,
Error: 2601, Severity: 14, Cannot insert duplicate key row in object ‘%.*ls’ with unique index ‘%.*ls’. The duplicate key value is %ls.,
Error: 2627, Severity: 14, Violation of %ls constraint ‘%.*ls’. Cannot insert duplicate key in object ‘%.*ls’. The duplicate key value is %ls.,
Error: 2700, Severity: 16, There are too many statements in the batch; the maximum number is %d,
Error: 2701, Severity: 10, Database name ‘%.*ls’ ignored, referencing object in tempdb.,

Error: 2702, Severity: 16, Database ‘%.*ls’ does not exist.,
Error: 2703, Severity: 16, Cannot use duplicate column names in the partition columns list. Column name ‘%.*ls’ appears more than once.,
Error: 2704, Severity: 16, Invalid partition scheme ‘%.*ls’ specified.,
Error: 2705, Severity: 16, Column names in each table must be unique. Column name ‘%.*ls’ in table ‘%.*ls’ is specified more than once.,
Error: 2706, Severity: 11, Table ‘%.*ls’ does not exist.,
Error: 2707, Severity: 16, Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it depends on a non-schemabound object.,
Error: 2709, Severity: 16, Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it does user or system data access.,
Error: 2710, Severity: 16, You are not the owner specified for the object ‘%.*ls’ in this statement (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS or BULK INSERT).,

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *