SQL Server

SQL Server Error Msg 21581 – Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of  2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article has a join filter with a join_unique_key value of 0. Either select a value of 0 or 1 for the @partition_options parameter, or use sp_changemergefilter to specify a value of 1 for join_unique_key.

SQL Server Error Msg 45172 – The ‘MaximumLag’ parameter requires that ‘IsContinuous’ is specified.

SQL Server Error Msg 14693 – A collection set cannot start without a schedule. Specify a schedule for the collection set.

SQL Server Error Msg 11705 – The minimum value for sequence object ‘%.*ls’ must be less than its maximum value.

SQL Server Error Msg 19030 – SQL Trace ID %d was started by login “%s”.

SQL Server Error Msg 1008 – The SELECT item identified by the ORDER BY number %d contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.

SQL Server Error Msg 3990 – Transaction is not allowed to commit inside of a user defined routine, trigger or aggregate because the transaction is not started in that CLR level. Change application logic to enforce strict transaction nesting.

SQL Server Error Msg 21085 – The retention period must be less than the retention period for the distribution database.

SQL Server Error Msg 6530 – Cannot perform alter on ‘%.*ls’ because it is an incompatible object type.

SQL Server Error Msg 40919 – The server ‘%.*ls’ is currently the primary server in the Failover Group and cannot initate failover

SQL Server Error Msg 17263 – Contained availability group master database not available for server state initialization during startup.

SQL Server Error Msg 35352 – %S_MSG statement failed because the operation cannot be performed online on a table with a columnstore index. Perform the operation without specifying the ONLINE option or drop (or disable) the columnstore index before performing the operation using the ONLINE option.

SQL Server Error Msg 14156 – The custom stored procedure calling the format for the %s command specified in the article definition does not match the %s format.

SQL Server Error Msg 21011 – Deactivated subscriptions.

SQL Server Error Msg 11253 – A corrupted message has been received. The service pair security header destination certificate, the key exchange key, the key exchange key ID, and the session key must all be present or all be absent. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.

SQL Server Error Msg 1104 – TEMPDB ran out of space during spilling. Create space by dropping objects and/or rewrite the query to consume fewer rows. If the issue still persists, consider upgrading to a higher service level objective.

SQL Server Error Msg 40564 – Database copy failed. Database copy failed due to an internal error. Please drop target database and try again.

SQL Server 101 – GROUP BY datetime and ignore time

SQL Server Error Msg 7967 – Clustered columnstore index ‘%.*ls’ on table ‘%.*ls’ has a missing column segment on column id %d and rowgroup id %d. Restore the data from a backup.

SQL Server Error Msg 19124 – Unable to retrieve registry settings for a specific IP address.