Tag: MS SQL Server Error Codes
SQL Server Error Code – 10781 querytraceon %d and optimizer hint ‘%.*l
In this blog post, you’ll learn more about the SQL Server Error Code 10781 and the error message description that is shown SQL Server Error Code 10781 SQL Server Error Description for the Code :10781 Querytraceon %d and optimizer hint ‘%.*ls’ specify conflicting behaviors. Remove one of them and rerun the query.
SQL Server Error Code – 11506 the parameter type for ‘%.*ls’ cannot be
In this blog post, you’ll learn more about the SQL Server Error Code 11506 and the error message description that is shown SQL Server Error Code 11506 SQL Server Error Description for the Code :11506 The parameter type for ‘%.*ls’ cannot be uniquely deduced; two possibilities are ‘%ls’ and ‘%ls’.
SQL Server Error Code – 13587 period column ‘%.*ls’ in a system-versio
In this blog post, you’ll learn more about the SQL Server Error Code 13587 and the error message description that is shown SQL Server Error Code 13587 SQL Server Error Description for the Code :13587 Period column ‘%.*ls’ in a system-versioned temporal table cannot be nullable.
SQL Server Error Code – 15204 there are no remote logins for ‘%s’ on r
In this blog post, you’ll learn more about the SQL Server Error Code 15204 and the error message description that is shown SQL Server Error Code 15204 SQL Server Error Description for the Code :15204 There are no remote logins for ‘%s’ on remote server ‘%s’.
SQL Server Error Code – 27154 the @sensitive parameter is missing. thi
In this blog post, you’ll learn more about the SQL Server Error Code 27154 and the error message description that is shown SQL Server Error Code 27154 SQL Server Error Description for the Code :27154 The @sensitive parameter is missing. This parameter is used to indicate if the parameter contains a sensitive value.
SQL Server Error Code – 41406 the availability group is not ready for
In this blog post, you’ll learn more about the SQL Server Error Code 41406 and the error message description that is shown SQL Server Error Code 41406 SQL Server Error Description for the Code :41406 The availability group is not ready for automatic failover. The primary replica and a secondary replica are configured for automatic failover, however, the secondary replica is not ready for an…
SQL Server Error Code – 45378 geo-redundant-backup not supported for t
In this blog post, you’ll learn more about the SQL Server Error Code 45378 and the error message description that is shown SQL Server Error Code 45378 SQL Server Error Description for the Code :45378 geo-redundant-backup not supported for the current edition.
SQL Server Error Code – 6348 specified collection ‘%.*ls’ cannot be c
In this blog post, you’ll learn more about the SQL Server Error Code 6348 and the error message description that is shown SQL Server Error Code 6348 SQL Server Error Description for the Code :6348 Specified collection ‘%.*ls’ cannot be created because it already exists or you do not have permission.
SQL Server Error Code – 21549 cannot add the computed column ‘%s’ to t
In this blog post, you’ll learn more about the SQL Server Error Code 21549 and the error message description that is shown SQL Server Error Code 21549 SQL Server Error Description for the Code :21549 Cannot add the computed column ‘%s’ to the publication. You must first add all columns on which this column depends; you cannot filter any of these colunmns from the article.
SQL Server Error Code – 20081 publication property ‘%s’ cannot be null
In this blog post, you’ll learn more about the SQL Server Error Code 20081 and the error message description that is shown SQL Server Error Code 20081 SQL Server Error Description for the Code :20081 Publication property ‘%s’ cannot be NULL.
SQL Server Error Code – 30072 during the database upgrade, the full-te
In this blog post, you’ll learn more about the SQL Server Error Code 30072 and the error message description that is shown SQL Server Error Code 30072 SQL Server Error Description for the Code :30072 During the database upgrade, the full-text protocol handler component ‘%ls’ that is used by catalog ‘%ls’ was successfully verified. Component version is ‘%ls’. Full path is ‘%.*ls’. Program ID is…
SQL Server Error Code – 40666 ‘%.*ls’ is a unicode-only collation and
In this blog post, you’ll learn more about the SQL Server Error Code 40666 and the error message description that is shown SQL Server Error Code 40666 SQL Server Error Description for the Code :40666 ‘%.*ls’ is a unicode-only collation and cannot be a default collation for a database.
SQL Server Error Code – 802 there is insufficient memory available i
In this blog post, you’ll learn more about the SQL Server Error Code 802 and the error message description that is shown SQL Server Error Code 802 SQL Server Error Description for the Code :802 There is insufficient memory available in the buffer pool.
SQL Server Error Code – 1758 only a single constraint can be added or
In this blog post, you’ll learn more about the SQL Server Error Code 1758 and the error message description that is shown SQL Server Error Code 1758 SQL Server Error Description for the Code :1758 Only a single constraint can be added or dropped online with no other operations in the same statement.
SQL Server Error Code – 12357 indexes on character columns that use a
In this blog post, you’ll learn more about the SQL Server Error Code 12357 and the error message description that is shown SQL Server Error Code 12357 SQL Server Error Description for the Code :12357 Indexes on character columns that use a UTF8 collation are not supported with %S_MSG.
SQL Server Error Code – 13515 setting system_versioning to on failed b
In this blog post, you’ll learn more about the SQL Server Error Code 13515 and the error message description that is shown SQL Server Error Code 13515 SQL Server Error Description for the Code :13515 Setting SYSTEM_VERSIONING to ON failed because history table ‘%.*ls’ has custom unique keys defined. Consider dropping all unique keys and trying again.
SQL Server Error Code – 47007 reason: fedauth rps authentication faile
In this blog post, you’ll learn more about the SQL Server Error Code 47007 and the error message description that is shown SQL Server Error Code 47007 SQL Server Error Description for the Code :47007 Reason: FedAuth RPS Authentication failed during SetAuthPolicy.
SQL Server Error Code – 1081 %s does not allow specifying the databas
In this blog post, you’ll learn more about the SQL Server Error Code 1081 and the error message description that is shown SQL Server Error Code 1081 SQL Server Error Description for the Code :1081 %s does not allow specifying the database name as a prefix to the assembly name.
SQL Server Error Code – 3919 cannot enlist in the transaction because
In this blog post, you’ll learn more about the SQL Server Error Code 3919 and the error message description that is shown SQL Server Error Code 3919 SQL Server Error Description for the Code :3919 Cannot enlist in the transaction because the transaction has already been committed or rolled back.
SQL Server Error Code – 7902 columnstore index ‘%.*ls’ on table ‘%.*l
In this blog post, you’ll learn more about the SQL Server Error Code 7902 and the error message description that is shown SQL Server Error Code 7902 SQL Server Error Description for the Code :7902 Columnstore index ‘%.*ls’ on table ‘%.*ls’ has metadata mismatch on column id %d and rowgroup id %d. If this is a nonclustered columnstore index, drop it and recreate it. Otherwise,…