SQL Server Errors or Failures from Error: 12010 to Error: 12800

SQLServerF1

 

Error: 12010, Severity: 16, Only one spatial index hint may appear per table, either as the first or the last hinted index.
Error: 12011, Severity: 16, The value of parameter ‘%.*ls’ of CREATE %S_MSG must be less than %d.
Error: 12012, Severity: 16, The value of parameter ‘%.*ls’ of CREATE %S_MSG must be greater than %d.
Error: 12013, Severity: 16, The value of parameter ‘%.*ls’ of CREATE %S_MSG must be greater than the value of parameter ‘%.*ls’.

Error: 12014, Severity: 16, The ‘%.*ls’ parameter of CREATE %S_MSG is incompletely defined. If the parameter has more than one part, all the parts must be defined.
Error: 12015, Severity: 16, The index option %.*ls in the CREATE %S_MSG statement has to appear before the general index options.
Error: 12016, Severity: 16, Creating a %S_MSG index requires that the primary key in the base table satisfy the following restrictions. The maximum number of primary-key columns is %d. The maximum combined per-row size of the primary-key columns is %d bytes. The primary key on the
Error: 12017, Severity: 10, The spatial index is disabled or offline
Error: 12018, Severity: 10, The spatial object is not defined in the scope of the predicate
Error: 12019, Severity: 10, Spatial indexes do not support the comparand supplied in the predicate

Error: 12020, Severity: 10, Spatial indexes do not support the comparator supplied in the predicate
Error: 12021, Severity: 10, Spatial indexes do not support the method name supplied in the predicate
Error: 12022, Severity: 10, The comparand references a column that is defined below the predicate
Error: 12023, Severity: 10, The comparand in the comparison predicate is not deterministic
Error: 12024, Severity: 10, The spatial parameter references a column that is defined below the predicate
Error: 12025, Severity: 10, Could not find required binary spatial method in a condition
Error: 12026, Severity: 10, Could not find required comparison predicate
Error: 12101, Severity: 16, Cannot disable change tracking on database ‘%.*ls’ while client connections are waiting on change notification. Please close those connections before disabling change tracking.
Error: 12104, Severity: 15, ALTER DATABASE CURRENT failed because ‘%.*ls’ is a system database. System databases cannot be altered by using the CURRENT keyword. Use the database name to alter a system database.
Error: 12800, Severity: 16, The reference to temp table name ‘%.*ls’ is ambiguous and cannot be resolved. Use either ‘%.*ls’ or ‘%.*ls’.

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.

Thanks,
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 *