Category: SQL Server
SQL Server Error Code – 8562 the connection has been lost with micros
In this blog post, you’ll learn more about the SQL Server Error Code 8562 and the error message description that is shown SQL Server Error Code 8562 SQL Server Error Description for the Code :8562 The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection…
SQL Server Error Code – 13187 the certificate’s public key size is inc
In this blog post, you’ll learn more about the SQL Server Error Code 13187 and the error message description that is shown SQL Server Error Code 13187 SQL Server Error Description for the Code :13187 The certificate’s public key size is incompatible with the security header’s signature
SQL Server Error Code – 21817 the property ‘%s’ is only valid for push
In this blog post, you’ll learn more about the SQL Server Error Code 21817 and the error message description that is shown SQL Server Error Code 21817 SQL Server Error Description for the Code :21817 The property ‘%s’ is only valid for push subscriptions.
SQL Server Error Code – 35204 the connection between server instances
In this blog post, you’ll learn more about the SQL Server Error Code 35204 and the error message description that is shown SQL Server Error Code 35204 SQL Server Error Description for the Code :35204 The connection between server instances ‘%ls’ with id [%ls] and ‘%ls’ with id [%ls] has been disabled because the database mirroring endpoint was either disabled or stopped. Restart the endpoint…
SQL Server Error Code – 45218 @encryptor_type, and @encryptor_name mus
In this blog post, you’ll learn more about the SQL Server Error Code 45218 and the error message description that is shown SQL Server Error Code 45218 SQL Server Error Description for the Code :45218 @encryptor_type, and @encryptor_name must be specified if @encryption_algorithm is not set to ‘NO_ENCRYPTION’
SQL Server Error Code – 8537 this transaction was aborted by kernel t
In this blog post, you’ll learn more about the SQL Server Error Code 8537 and the error message description that is shown SQL Server Error Code 8537 SQL Server Error Description for the Code :8537 This transaction was aborted by Kernel Transaction Manager (KTM).
How to find the duplicate records on certain fields in SQL Server ?
You can use the group by and having clause in your T-SQL query to find out the duplicate records from the table. How to find the duplicate records on certain fields in SQL Server ? Lets have a look at the query that uses the group by and having clause on the Person table in the AdventureWorks database. The firstname column is used as the…
SQL Server Error Code – 6636 unable to read the compressed showplan x
In this blog post, you’ll learn more about the SQL Server Error Code 6636 and the error message description that is shown SQL Server Error Code 6636 SQL Server Error Description for the Code :6636 Unable to read the compressed showplan xml because it was made with a newer version of SQL server.
SQL Server Error Code – 8143 parameter ‘%.*ls’ was supplied multiple
In this blog post, you’ll learn more about the SQL Server Error Code 8143 and the error message description that is shown SQL Server Error Code 8143 SQL Server Error Description for the Code :8143 Parameter ‘%.*ls’ was supplied multiple times.
SQL Server Error Code – 8155 no column name was specified for column
In this blog post, you’ll learn more about the SQL Server Error Code 8155 and the error message description that is shown SQL Server Error Code 8155 SQL Server Error Description for the Code :8155 No column name was specified for column %d of ‘%.*ls’.
SQL Server Error Code – 46644 external tables for sharded data
In this blog post, you’ll learn more about the SQL Server Error Code 46644 and the error message description that is shown SQL Server Error Code 46644 SQL Server Error Description for the Code :46644 external tables for sharded data
SQL Server Error Code – 2387 %scannot have both ?type? and ?ref? attr
In this blog post, you’ll learn more about the SQL Server Error Code 2387 and the error message description that is shown SQL Server Error Code 2387 SQL Server Error Description for the Code :2387 %sCannot have both ?type? and ?ref? attributes. Location: ?%ls?.