Category: SQL Server

SQL Server Error Code – 21720 cannot find a job that matches the id or

In this blog post, you’ll learn more about the SQL Server Error Code 21720 and the error message description that is shown SQL Server Error Code 21720 SQL Server Error Description for the Code :21720 Cannot find a job that matches the ID or name specified in the parameters @dynamic_snapshot_jobid or @dynamic_snapshot_jobname. Verify the values specified for those parameters.

SQL Server Error Code – 2798 cannot create index or statistics ?%.*ls

In this blog post, you’ll learn more about the SQL Server Error Code 2798 and the error message description that is shown SQL Server Error Code 2798 SQL Server Error Description for the Code :2798 Cannot create index or statistics ?%.*ls? on table ?%.*ls? because SQL Server cannot verify that key column ?%.*ls? is precise and deterministic. Consider removing column from index or statistics key,…

SQL Server Error Code – 20650 cannot enable data definition language (

In this blog post, you’ll learn more about the SQL Server Error Code 20650 and the error message description that is shown SQL Server Error Code 20650 SQL Server Error Description for the Code :20650 Cannot enable data definition language (DDL) replication (a value of “true” for the @replicate_ddl parameter) for publication “%s”. This is because the compatibility level of the publication is lower than…

SQL Server Error Code – 1478 the mirror database, ?%.*ls?, has insuff

In this blog post, you’ll learn more about the SQL Server Error Code 1478 and the error message description that is shown SQL Server Error Code 1478 SQL Server Error Description for the Code :1478 The mirror database, ?%.*ls?, has insufficient transaction log data to preserve the log backup chain of the principal database.? This may happen if a log backup from the principal database…

SQL Server Error Code – 10088 the order of the columns was not specifi

In this blog post, you’ll learn more about the SQL Server Error Code 10088 and the error message description that is shown SQL Server Error Code 10088 SQL Server Error Description for the Code :10088 The order of the columns was not specified in the object that created the rowset. The provider had to reexecute the command to reposition the next fetch position to its…