title: Does deadlock cause any active connection to be timed out/break?
body: <p>I have a basic SQL question, If there are two active connections, "A" and "B" to the SQL server, and let say a deadlock occurs between the two, so to avoid deadlock SQL server will roll back one of the transactions, either of connection "A" or of "B". Let say SQL server roll back the transaction of connection "A", does this roll back of transaction can cause a connection timeout/connection break for the connection A also? –</p>