Category: SQL Server

SQL Server Error Code – 19409 the windows server failover clustering (

In this blog post, you’ll learn more about the SQL Server Error Code 19409 and the error message description that is shown SQL Server Error Code 19409 SQL Server Error Description for the Code :19409 The Windows Server Failover Clustering (WSFC) cluster context of Always On Availability Groups has been changed to the local WSFC cluster. An ALTER SERVER CONFIGURATION SET HADR CLUSTER LOCAL command…

SQL Server Error Code – 5605 the password for sa account could not be

In this blog post, you’ll learn more about the SQL Server Error Code 5605 and the error message description that is shown SQL Server Error Code 5605 SQL Server Error Description for the Code :5605 The password for SA account could not be force regenerated and/or SA account cannot be disabled as requested by the -K startup option and the -T1617 trace flag.

SQL Server Error Code – 40978 instance failover group cannot be create

In this blog post, you’ll learn more about the SQL Server Error Code 40978 and the error message description that is shown SQL Server Error Code 40978 SQL Server Error Description for the Code :40978 Instance failover group cannot be created because the reserved storage size on the secondary instance is different from the reserved storage size on the primary instance.

SQL Server Error Code – 47138 joining contained availability group ‘%.

In this blog post, you’ll learn more about the SQL Server Error Code 47138 and the error message description that is shown SQL Server Error Code 47138 SQL Server Error Description for the Code :47138 Joining contained availability group ‘%.*ls’ without rebuilding contained system DB has failed because availability group master ‘%.*ls’ had incorrect db id ‘%ld’. Please use rebuild_system_databases option or remove availability group…

SQL Server Error Code – 8685 query cannot be compiled because

In this blog post, you’ll learn more about the SQL Server Error Code 8685 and the error message description that is shown SQL Server Error Code 8685 SQL Server Error Description for the Code :8685 Query cannot be compiled because element appears in XML plan provided to USE PLAN but USE PLAN was applied to a non-cursor statement. Consider using an XML plan obtained from…

SQL Server Error Code – 30035 the search property ‘%.*ls’ already exis

In this blog post, you’ll learn more about the SQL Server Error Code 30035 and the error message description that is shown SQL Server Error Code 30035 SQL Server Error Description for the Code :30035 The search property ‘%.*ls’ already exists in the search property list. Specify a search property name that is unique within the specified search property list. For a list of the…