Tag: MS SQL Server Error Codes

SQL Server Error Code – 40802 a service objective assignment on server

In this blog post, you’ll learn more about the SQL Server Error Code 40802 and the error message description that is shown SQL Server Error Code 40802 SQL Server Error Description for the Code :40802 A service objective assignment on server ‘%.*ls’ and database ‘%.*ls’ is already in progress. Please wait until the service objective assignment state for the database is marked as ‘Completed’.

SQL Server Error Code – 10513 cannot %s_msg %s_msg ‘%.*ls’ because it

In this blog post, you’ll learn more about the SQL Server Error Code 10513 and the error message description that is shown SQL Server Error Code 10513 SQL Server Error Description for the Code :10513 Cannot %S_MSG %S_MSG ‘%.*ls’ because it is referenced by plan guide ‘%.*ls’. Use sp_control_plan_guide to drop the plan guide first. Record the plan guide definition for future use if needed.

SQL Server Error Code – 35386 unable to allocate %i64d kb for columnst

In this blog post, you’ll learn more about the SQL Server Error Code 35386 and the error message description that is shown SQL Server Error Code 35386 SQL Server Error Description for the Code :35386 Unable to allocate %I64d KB for columnstore compression because it exceeds the remaining memory from total allocated for current resource class and DWU. Please rerun query at a higher resource…

SQL Server Error Code – 10539 cannot create plan guide ‘%.*ls’ from ca

In this blog post, you’ll learn more about the SQL Server Error Code 10539 and the error message description that is shown SQL Server Error Code 10539 SQL Server Error Description for the Code :10539 Cannot create plan guide ‘%.*ls’ from cache because a query plan is not available for the statement with start offset %d.This problem can occur if the statement depends on database…

SQL Server Error Code – 21358 warning: only subscribers running sql se

In this blog post, you’ll learn more about the SQL Server Error Code 21358 and the error message description that is shown SQL Server Error Code 21358 SQL Server Error Description for the Code :21358 Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication ‘%s’ because at least one timestamp column exists in one of its articles.

SQL Server Error Code – 33123 cannot drop or alter the database encryp

In this blog post, you’ll learn more about the SQL Server Error Code 33123 and the error message description that is shown SQL Server Error Code 33123 SQL Server Error Description for the Code :33123 Cannot drop or alter the database encryption key since it is currently in use on a mirror or secondary availability replica. Retry the command after all the previous reencryption scans…

SQL Server Error Code – 4968 alter table switch statement failed. tar

In this blog post, you’ll learn more about the SQL Server Error Code 4968 and the error message description that is shown SQL Server Error Code 4968 SQL Server Error Description for the Code :4968 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has foreign key for constraint ‘%.*ls’ but source table ‘%.*ls’ does not have corresponding key.