Category: SQL Server
SQL Server Error Code – 1543 sql server encountered: ?%ls? resulting
In this blog post, you’ll learn more about the SQL Server Error Code 1543 and the error message description that is shown SQL Server Error Code 1543 SQL Server Error Description for the Code :1543 SQL Server encountered: ?%ls? resulting from an attempt to read the following: sort run page %S_PGID, in file ?%ls?, in database with ID %d. Sort is retrying the read.
SQL Server Error Code – 13186 the certificate’s private key size is in
In this blog post, you’ll learn more about the SQL Server Error Code 13186 and the error message description that is shown SQL Server Error Code 13186 SQL Server Error Description for the Code :13186 The certificate’s private key size is incompatible with the encrypted key exchange key
SQL Server Error Code – 40002 replicated row is not found.
In this blog post, you’ll learn more about the SQL Server Error Code 40002 and the error message description that is shown SQL Server Error Code 40002 SQL Server Error Description for the Code :40002 Replicated row is not found.
SQL Server Error Code – 3287 the file id %d on device ?%ls? is incorr
In this blog post, you’ll learn more about the SQL Server Error Code 3287 and the error message description that is shown SQL Server Error Code 3287 SQL Server Error Description for the Code :3287 The file ID %d on device ?%ls? is incorrectly formed and can not be read.
SQL Server Error Code – 13701 system-versioned table schema modificati
In this blog post, you’ll learn more about the SQL Server Error Code 13701 and the error message description that is shown SQL Server Error Code 13701 SQL Server Error Description for the Code :13701 System-versioned table schema modification failed because history table ‘%.*ls’ has custom unique keys defined. Consider dropping all unique keys and trying again.
SQL Server Error Code – 22583 article ‘%s’ cannot be added or modified
In this blog post, you’ll learn more about the SQL Server Error Code 22583 and the error message description that is shown SQL Server Error Code 22583 SQL Server Error Description for the Code :22583 Article ‘%s’ cannot be added or modified in publication ‘%s’. The replication of FILESTREAM columns is not supported for articles that have a ‘schema_option’ set to 0x20000000. This converts large…
SQL Server Error Code – 28005 an exception occurred while enqueueing a
In this blog post, you’ll learn more about the SQL Server Error Code 28005 and the error message description that is shown SQL Server Error Code 28005 SQL Server Error Description for the Code :28005 An exception occurred while enqueueing a message in the target queue. Error: %d, State: %d. %.*ls
SQL Server Error Code – 41086 failed to retrieve the paxos tag from th
In this blog post, you’ll learn more about the SQL Server Error Code 41086 and the error message description that is shown SQL Server Error Code 41086 SQL Server Error Description for the Code :41086 Failed to retrieve the Paxos tag from the Windows Server Failover Clustering (WSFC) registry hive. The WSFC registry hive might be corrupt. Verify whether the ‘HKLM\Cluster\PaxosTag’ registry value exists in…
SQL Server Error Code – 43016 the value ‘%.*ls’ for configuration ‘%.*
In this blog post, you’ll learn more about the SQL Server Error Code 43016 and the error message description that is shown SQL Server Error Code 43016 SQL Server Error Description for the Code :43016 The value ‘%.*ls’ for configuration ‘%.*ls’ is not valid. The allowed values are ‘%.*ls’.
Checking the version of a SQL Server using T-SQL
There are couple of ways in which you can retreive the version of the SQL Server using T-SQL. Checking the version of a SQL Server using T-SQL 1. using @@VERSION 2. Using SERVERPROPERTY function as shown
SQL Server Error Code – 1086 the for xml and for json clauses are inv
In this blog post, you’ll learn more about the SQL Server Error Code 1086 and the error message description that is shown SQL Server Error Code 1086 SQL Server Error Description for the Code :1086 The FOR XML and FOR JSON clauses are invalid in views, inline functions, derived tables, and subqueries when they contain a set operator. To work around, wrap the SELECT containing…
SQL Server Error Code – 4014 a fatal error occurred while reading the
In this blog post, you’ll learn more about the SQL Server Error Code 4014 and the error message description that is shown SQL Server Error Code 4014 SQL Server Error Description for the Code :4014 A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: %d, output error: %d).