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 – 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…

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…