Category: SQL Server

SQL Server Error Code – 49902 there are not enough worker threads avai

In this blog post, you’ll learn more about the SQL Server Error Code 49902 and the error message description that is shown SQL Server Error Code 49902 SQL Server Error Description for the Code :49902 There are not enough worker threads available for the number of CPUs. This is because one or more CPUs were added. To increase the number of worker threads, use sp_configure…

SQL Server Error Code – 1051 cursor parameters in a stored procedure

In this blog post, you’ll learn more about the SQL Server Error Code 1051 and the error message description that is shown SQL Server Error Code 1051 SQL Server Error Description for the Code :1051 Cursor parameters in a stored procedure must be declared with OUTPUT and VARYING options, and they must be specified in the order CURSOR VARYING OUTPUT.

SQL Server Error Code – 8642 the query processor could not start the

In this blog post, you’ll learn more about the SQL Server Error Code 8642 and the error message description that is shown SQL Server Error Code 8642 SQL Server Error Description for the Code :8642 The query processor could not start the necessary thread resources for parallel query execution. Reduce load on the server or use the MAXDOP setting to limit parallelism.

SQL Server Error Code – 14631 the current user (‘%s’) either does not

In this blog post, you’ll learn more about the SQL Server Error Code 14631 and the error message description that is shown SQL Server Error Code 14631 SQL Server Error Description for the Code :14631 The current user (‘%s’) either does not have permission to access the database specified in the parameter @execute_query_database or cannot impersonate the user specified in the parameter @execute_query_as. Only members…

SQL Server Error Code – 41146 failed to bring availability group ‘%.*l

In this blog post, you’ll learn more about the SQL Server Error Code 41146 and the error message description that is shown SQL Server Error Code 41146 SQL Server Error Description for the Code :41146 Failed to bring Availability Group ‘%.*ls’ online.  If this is a WSFC availability group, the Windows Server Failover Clustering (WSFC) service may not be running, or it may not be…

SQL Server Error Code – 3953 snapshot isolation transaction failed in

In this blog post, you’ll learn more about the SQL Server Error Code 3953 and the error message description that is shown SQL Server Error Code 3953 SQL Server Error Description for the Code :3953 Snapshot isolation transaction failed in database ?%.*ls? because the database was not recovered when the current transaction was started. Retry the transaction after the database has recovered.