Category: SQL Server

SQL Server Error Code – 13766 cannot drop the clustered index ‘%.*ls’

In this blog post, you’ll learn more about the SQL Server Error Code 13766 and the error message description that is shown SQL Server Error Code 13766 SQL Server Error Description for the Code :13766 Cannot drop the clustered index ‘%.*ls’ because it is being used for automatic cleanup of aged data. Consider setting HISTORY_RETENTION_PERIOD to INFINITE on the corresponding system-versioned temporal table if you…

SQL Server Error Code – 17883 process %ld:%ld:%ld (0x%lx) worker 0x%p

In this blog post, you’ll learn more about the SQL Server Error Code 17883 and the error message description that is shown SQL Server Error Code 17883 SQL Server Error Description for the Code :17883 Process %ld:%ld:%ld (0x%lx) Worker 0x%p appears to be non-yielding on Scheduler %ld. Thread creation time: %I64d. Approx Thread CPU Used: kernel %I64d ms, user %I64d ms. Process Utilization %d%%. System…

SQL Server Error Code – 978 the target database (?%.*ls?) is in an a

In this blog post, you’ll learn more about the SQL Server Error Code 978 and the error message description that is shown SQL Server Error Code 978 SQL Server Error Description for the Code :978 The target database (?%.*ls?) is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent,…

SQL Server Error Code – 20802 cannot publish objects from the replicat

In this blog post, you’ll learn more about the SQL Server Error Code 20802 and the error message description that is shown SQL Server Error Code 20802 SQL Server Error Description for the Code :20802 Cannot publish objects from the replication administrative user schema [%s]. This schema owns all replication procedures and metadata tables, but it cannot own published objects. Use a different schema for…