SQL Server Errors or Failures from Error: 10784 to Error: 10913


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

Error: 10784, Severity: 16,
The WITH clause of BEGIN ATOMIC statement must specify value for the option ‘%ls’.

Error: 10785, Severity: 15,
The %S_MSG ‘%ls’ is not supported with an active xtp transaction.

Error: 10786, Severity: 16,
The ALTER AVAILABILITY GROUP command failed because it contained multiple MODIFY REPLICA options: %ls. Enter a separate ALTER AVAILABILITY GROUP … MODIFY REPLICA command for each replica option that you want to modify.

Error: 10800, Severity: 16,
The listener for the WSFC resource ‘%.*ls’ failed to start, and returned error code %d, ‘%.*ls’. For more information about this error code, see “System Error Codes” in the Windows Development Documentation.

Error: 10801, Severity: 16,
Failed to stop the listener for Windows Failover Cluster resource ‘%.*ls’. Error: %d. %.*ls

Error: 10802, Severity: 10,
Failed to enqueue a task to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is added manually or SQL Server is restarted. SQLOS error code: %d.

Error: 10900, Severity: 16,
Failed to configure resource governor during startup. Check SQL Server error log for specific error messages or check the consistency of master database by running DBCC CHECKCATALOG(‘master’).

Error: 10901, Severity: 16,
User does not have permission to alter the resource governor configuration.

Error: 10902, Severity: 16,
User-defined function ‘%s’ does not exist in master database, or the user does not have permission to access it.

Error: 10903, Severity: 16,
The specified schema name ‘%.*ls’ for classifier user-defined function either does not exist, or the user does not have permission to use it.

Error: 10904, Severity: 16,
Resource governor configuration failed. There are active sessions in workload groups being dropped or moved to different resource pools. Disconnect all active sessions in the affected workload groups and try again.

Error: 10905, Severity: 16,
Could not complete resource governor configuration because there is not enough memory. Reduce the server load or try the operation on a dedicated administrator connection.

Error: 10906, Severity: 16,
The object ‘%.*ls’.’%.*ls’ is not a valid resource governor classifier user-defined function. A valid classifier user-defined function must be schema-bound, return sysname, and have no parameters.

Error: 10907, Severity: 16,
Attribute ‘%.*ls’ with value of %u is greater than attribute ‘%.*ls’ with value of %u.

Error: 10908, Severity: 16,
Attribute ‘%.*ls’ with value of %u is less than attribute ‘%.*ls’ with value of %u.

Error: 10909, Severity: 16,
The resource pool cannot be created. The maximum number of resource pools cannot exceed current limit of %u including predefined resource pools.

Error: 10910, Severity: 16,
The operation could not be completed. The specified ‘%.*ls’ value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, so that the sum is less than o

Error: 10911, Severity: 16,
Requested operation cannot be performed because the resource pool ‘%.*ls’ does not exist.

Error: 10912, Severity: 16,
The operation could not be completed. Dropping predefined %S_MSG is not allowed.

Error: 10913, Severity: 16,
Users are not allowed to %S_MSG the workload group ‘%.*ls’ in the ‘%.*ls’ resource pool.

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 *