SQL Server Errors or Failures from Error: 11038 to Error: 11108

SQLServerF1

You may receive various errors in SQL Server while working. Below are some of the SQL Server Errors from Error: 11038 to Error: 11108

Error: 11038, Severity: 16,
The row is a pending insert row.

Error: 11039, Severity: 16,
DBPROP_CHANGEINSERTEDROWS was VARIANT_FALSE and the insertion for the row has been transmitted to the data source.

Error: 11040, Severity: 16,
Deleting the row violated the integrity constraints for the column or table.

Error: 11041, Severity: 16,
The row handle was invalid or was a row handle to which the current thread does not have access rights.

Error: 11042, Severity: 16,
Deleting the row would exceed the limit for pending changes specified by the rowset property DBPROP_MAXPENDINGROWS.

Error: 11043, Severity: 16,
The row has a storage object open.

Error: 11044, Severity: 16,
The provider ran out of memory and could not fetch the row.

Error: 11045, Severity: 16,
User did not have sufficient permission to delete the row.

Error: 11046, Severity: 16,
The table was in immediate-update mode and the row was not deleted due to reaching a limit on the server, such as query execution timing out.

Error: 11047, Severity: 16,
Updating did not meet the schema requirements.

Error: 11048, Severity: 16,
There was a recoverable, provider-specific error, such as an RPC failure.

Error: 11100, Severity: 16,
The provider indicates that conflicts occurred with other properties or requirements.

Error: 11101, Severity: 16,
Could not obtain an interface required for text, ntext, or image access.

Error: 11102, Severity: 16,
The provider could not support a required row lookup interface.

Error: 11103, Severity: 16,
The provider could not support an interface required for the UPDATE/DELETE/INSERT statements.

Error: 11104, Severity: 16,
The provider could not support insertion on this table.

Error: 11105, Severity: 16,
The provider could not support updates on this table.

Error: 11106, Severity: 16,
The provider could not support deletion on this table.

Error: 11107, Severity: 16,
The provider could not support a row lookup position.

Error: 11108, Severity: 16,
The provider could not support a required property.

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 *