Category: SQL Server
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.
How to display Row Numbers in the results in SQL Query ?
If you want to return the row number as a part of your results in the SQL Query , you can use the ROW_NUMBER function and specify the ORDER BY clause to it as shown in this blog post. How to display Row Numbers in the results in SQL Query ?
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,…
SQL Server Error Code – 18752 only one log reader agent or log-related
In this blog post, you’ll learn more about the SQL Server Error Code 18752 and the error message description that is shown SQL Server Error Code 18752 SQL Server Error Description for the Code :18752 Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over…
SQL Server Error Code – 28065 a corrupted message has been received. t
In this blog post, you’ll learn more about the SQL Server Error Code 28065 and the error message description that is shown SQL Server Error Code 28065 SQL Server Error Description for the Code :28065 A corrupted message has been received. The unsigned dialog message header is invalid. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
SQL Server Error Code – 28976 configuration manager agent is ignoring
In this blog post, you’ll learn more about the SQL Server Error Code 28976 and the error message description that is shown SQL Server Error Code 28976 SQL Server Error Description for the Code :28976 Configuration manager agent is ignoring stale message from manager brick %d due to ‘%s’ mismatch. Expected %I64u but received %I64u