OffOn
    Register
    HomeSQL ServerPage 659

    SQL Server

    Showing 13161 - 13180 of 14077 results
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “21581 – Article “%s” in publication “%s” does not qualify...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “45172 – The ‘MaximumLag’ parameter requires that ‘IsContinuous’ is specified.”...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “14693 – A collection set cannot start without a schedule....
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “11705 – The minimum value for sequence object ‘%.*ls’ must...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “19030 – SQL Trace ID %d was started by login...
    Read more
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “1008 – The SELECT item identified by the ORDER BY...
    Read more
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “3990 – Transaction is not allowed to commit inside of...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “21085 – The retention period must be less than the...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “6530 – Cannot perform alter on ‘%.*ls’ because it is...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “40919 – The server ‘%.*ls’ is currently the primary server...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “17263 – Contained availability group master database not available for...
    Read more
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “35352 – %S_MSG statement failed because the operation cannot be...
    Read more
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “14156 – The custom stored procedure calling the format for...
    Read more
    code coder coding computer

    SQL Server Error Msg 21011 – Deactivated subscriptions.

    In this blog post, let’s learn about the error message “21011 – Deactivated subscriptions.” in Microsoft SQL Server, the reason...
    Read more
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “11253 – A corrupted message has been received. The service...
    Read more
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “1104 – TEMPDB ran out of space during spilling. Create...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “40564 – Database copy failed. Database copy failed due to...
    Read more

    SQL Server 101 – GROUP BY datetime and ignore time

    Assume that you have a Order table and you want to query the table to retreive the total orders made...
    Read more
    code coder coding computer

    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.

    In this blog post, let’s learn about the error message “7967 – Clustered columnstore index ‘%.*ls’ on table ‘%.*ls’ has...
    Read more
    code coder coding computer

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

    In this blog post, let’s learn about the error message “19124 – Unable to retrieve registry settings for a specific...
    Read more

    Categories

    Archives
    Tags
    c# C# Compiler Errors C# Programs C++ examples C programs csharp DB2 Errors Delphi Errors Download Excel Excel 2016 Excel Automation excel functions excel tips excel tutorials Excel VBA Functions in Excel how to HPE NonStop SQL/MX Java examples Microsoft Microsoft Excel MS Office MySQL Errors Oracle Errors Outlook Errors PolarDB for PostgreSQL Python examples python programs SQL Server SQL Server Errors Sybase Error Message tips tricks troubleshoot Visual Studio Visual Studio 2012 Win32 Windows 11 Windows 11 tutorials Windows BSOD Errors windows phone windows phone 8 Windows Store wp8