Category: SQL Server
SQL Server Error Code – 4101 aggregates on the right side of an apply
In this blog post, you’ll learn more about the SQL Server Error Code 4101 and the error message description that is shown SQL Server Error Code 4101 SQL Server Error Description for the Code :4101 Aggregates on the right side of an APPLY cannot reference columns from the left side.
SQL Server Error Code – 17121 sql server is started with trace flag %d
In this blog post, you’ll learn more about the SQL Server Error Code 17121 and the error message description that is shown SQL Server Error Code 17121 SQL Server Error Description for the Code :17121 SQL Server is started with trace flag %d, this may cause user to see some error messages masked using ‘%ls’.
SQL Server Error Code – 21243 publisher ‘%s’, publication database ‘%s
In this blog post, you’ll learn more about the SQL Server Error Code 21243 and the error message description that is shown SQL Server Error Code 21243 SQL Server Error Description for the Code :21243 Publisher ‘%s’, publication database ‘%s’, and publication ‘%s’ could not be added to the list of synchronization partners.
SQL Server Error Code – 13508 system-versioned table cannot have more
In this blog post, you’ll learn more about the SQL Server Error Code 13508 and the error message description that is shown SQL Server Error Code 13508 SQL Server Error Description for the Code :13508 System-versioned table cannot have more than one SYSTEM_TIME period definition.
SQL Server Error Code – 21581 article “%s” in publication “%s” does no
In this blog post, you’ll learn more about the SQL Server Error Code 21581 and the error message description that is shown SQL Server Error Code 21581 SQL Server Error Description for the Code :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…
SQL Server Error Code – 2549 dbcc: defrag phase of index ?%.*ls? is %
In this blog post, you’ll learn more about the SQL Server Error Code 2549 and the error message description that is shown SQL Server Error Code 2549 SQL Server Error Description for the Code :2549 DBCC: Defrag phase of index ?%.*ls? is %d%% complete.
SQL Server Error Code – 3981 the transaction operation cannot be perf
In this blog post, you’ll learn more about the SQL Server Error Code 3981 and the error message description that is shown SQL Server Error Code 3981 SQL Server Error Description for the Code :3981 The transaction operation cannot be performed because there are pending requests working on this transaction.
SQL Server Error Code – 13165 conversation
In this blog post, you’ll learn more about the SQL Server Error Code 13165 and the error message description that is shown SQL Server Error Code 13165 SQL Server Error Description for the Code :13165 conversation
Alias Names for Tables in SQL Query
There are times when you write query and end up qualifying the columns references by indicating the table name. For example , In the above query , the Department table is referred in the GroupName and Name column. Instead of mentioning the table table , we could provide a shortname or alias name for the table and use the alias name instead. The full use…
SQL Server Error Code – 2531 table error: object id %d, index id %d,
In this blog post, you’ll learn more about the SQL Server Error Code 2531 and the error message description that is shown SQL Server Error Code 2531 SQL Server Error Description for the Code :2531 Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) B-tree level mismatch, page %S_PGID. Level %d does not match level %d from…
SQL Server Error Code – 9822 internal error occurred during time zone
In this blog post, you’ll learn more about the SQL Server Error Code 9822 and the error message description that is shown SQL Server Error Code 9822 SQL Server Error Description for the Code :9822 Internal error occurred during time zone data access.
SQL Server Error Code – 13194 authentication protocol
In this blog post, you’ll learn more about the SQL Server Error Code 13194 and the error message description that is shown SQL Server Error Code 13194 SQL Server Error Description for the Code :13194 authentication protocol