SQL Server Errors or Failures Error: 1509 to Error: 1708

Error: 1509, Severity: 20,
Row comparison failed during sort because of an unknown data type on a key column. Metadata might be corrupt. Contact Technical Support.
Error: 1510, Severity: 17,
Sort failed. Out of space or locks in database ‘%.*ls’.
Error: 1511, Severity: 20,
Sort cannot be reconciled with transaction log.
Error: 1522, Severity: 20,
Sort operation failed during an index build. The overwriting of the allocation page in database ‘%.*ls’ was prevented by terminating the sort. Run DBCC CHECKDB to check for allocation and consistency errors. It may be necessary restore the database from b
Error: 1523, Severity: 20,
Sort failure. The incorrect extent could not be deallocated. Contact Technical Support.
Error: 1532, Severity: 20,
New sort run starting on page %S_PGID found an extent not marked as shared. Retry the transaction. If the problem persists, contact Technical Support.
Error: 1533, Severity: 20,
Cannot share extent %S_PGID. The correct extents could not be identified. Retry the transaction.
Error: 1534, Severity: 20,
Extent %S_PGID not found in shared extent directory. Retry the transaction. If the problem persists, contact Technical Support.
Error: 1535, Severity: 20,
Cannot share extent %S_PGID. Shared extent directory is full. Retry the transaction. If the problem persists, contact Technical Support.
Error: 1537, Severity: 20,
Cannot suspend a sort that is not in row input phase.
Error: 1538, Severity: 20,
Cannot insert a row into a sort when the sort is not in row input phase.
Error: 1540, Severity: 16,
Cannot sort a row of size %d, which is greater than the allowable maximum of %d. Consider resubmitting the query using the ROBUST PLAN hint.
Error: 1541, Severity: 16,
Sort failure. A defective CLR type comparison function is suspected.
Error: 1542, Severity: 10,
BobMgr::GetBuf: Sort Big Output Buffer write not complete after %d seconds.
Error: 1543, Severity: 10,
SQL Server encountered: ‘%ls’ resulting from an attempt to read the following: sort run page %S_PGID, in file ‘%ls’, in database with ID %d. Sort is retrying the read.
Error: 1701, Severity: 16,
Creating or altering table ‘%.*ls’ failed because the minimum row size would be %d, including %d bytes of internal overhead. This exceeds the maximum allowable table row size of %d bytes.
Error: 1702, Severity: 16,
CREATE TABLE failed because column ‘%.*ls’ in table ‘%.*ls’ exceeds the maximum of %d columns.
Error: 1706, Severity: 16,
The system table ‘%.*ls’ can only be created or altered during an upgrade.
Error: 1707, Severity: 16,
Cannot specify TEXTIMAGE_ON filegroup for a partitioned table.
Error: 1708, Severity: 10,
Warning: The table “%.*ls” has been created, but its maximum row size exceeds the allowed maximum of %d bytes. INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit.
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.