Tag: MS SQL Server Error Codes

SQL Server Error Code – 22999 the value specified for the parameter @p

In this blog post, you’ll learn more about the SQL Server Error Code 22999 and the error message description that is shown SQL Server Error Code 22999 SQL Server Error Description for the Code :22999 The value specified for the parameter @pollinginterval must be null or 0 when the stored procedure ‘sys.sp_cdc_scan’ is not being run in continuous mode.

SQL Server Error Code – 41153 failed to create availability group ‘%.*

In this blog post, you’ll learn more about the SQL Server Error Code 41153 and the error message description that is shown SQL Server Error Code 41153 SQL Server Error Description for the Code :41153 Failed to create availability group ‘%.*ls’.  The operation encountered SQL Server error %d.  An attempt to roll back the operation failed.  Check the SQL Server error log for more details. …

SQL Server Error Code – 4993 alter table switch statement failed. the

In this blog post, you’ll learn more about the SQL Server Error Code 4993 and the error message description that is shown SQL Server Error Code 4993 SQL Server Error Description for the Code :4993 ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has different setting for Large Value Types Out Of Row table option as compared to table ‘%.*ls’.

SQL Server Error Code – 526 %ls of xml types constrained by differen

In this blog post, you’ll learn more about the SQL Server Error Code 526 and the error message description that is shown SQL Server Error Code 526 SQL Server Error Description for the Code :526 %ls of XML types constrained by different XML schema collections and/or DOCUMENT/CONTENT option is not allowed. Use the CONVERT function to run this query.

SQL Server Error Code – 21454 the internal procedure sp_mstran_is_snap

In this blog post, you’ll learn more about the SQL Server Error Code 21454 and the error message description that is shown SQL Server Error Code 21454 SQL Server Error Description for the Code :21454 The internal procedure sp_MStran_is_snapshot_required must be executed at the Distributor if the @run_at_distributor parameter has a value of 1. If the problem persists, contact Microsoft Customer Support Services.

SQL Server Error Code – 19470 failed to delete a resource in the wsfc

In this blog post, you’ll learn more about the SQL Server Error Code 19470 and the error message description that is shown SQL Server Error Code 19470 SQL Server Error Description for the Code :19470 Failed to delete a resource in the WSFC cluster because the resource ‘%.*ls’ is not offline. Delete the resource using the Failover Cluster Management tool (cluadmin.msc).