SQL Server Errors or Failures from Error: 10009 to Error: 10055



Error: 10009, Severity: 16, The provider did not give any information about the error.
Error: 10010, Severity: 16, The data necessary to complete this operation was not yet available to the provider.
Error: 10011, Severity: 16, Access denied.
Error: 10021, Severity: 16, Execution terminated by the provider because a resource limit was reached.
Error: 10022, Severity: 16, The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.

Error: 10023, Severity: 16, The provider does not support the necessary method.
Error: 10024, Severity: 16, The provider indicates that the user did not have the permission to perform the operation.
Error: 10025, Severity: 16, Provider caused a server fault in an external process.
Error: 10026, Severity: 16, No command text was set.
Error: 10027, Severity: 16, Command was not prepared.
Error: 10028, Severity: 16, Authentication failed.
Error: 10032, Severity: 16, Cannot return multiple result sets (not supported by the provider).
Error: 10033, Severity: 16, The specified index does not exist or the provider does not support an index scan on this data source.

Error: 10034, Severity: 16, The specified table or view does not exist or contains errors.
Error: 10035, Severity: 16, No value was given for one or more of the required parameters.
Error: 10042, Severity: 16, Cannot set any properties while there is an open rowset.
Error: 10052, Severity: 16, The insertion was canceled by the provider during notification.
Error: 10053, Severity: 16, Could not convert the data value due to reasons other than sign mismatch or overflow.
Error: 10054, Severity: 16, The data value for one or more columns overflowed the type used by the provider.
Error: 10055, Severity: 16, The data violated the integrity constraints for one or more columns.

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 *