How can I capture queries that fail on the SQL Server due to connection failures?

How can I capture queries that fail on the SQL Server due to connection failures?

Profiler doesnt seem to capture if there is a connectivity loss.

This is scenario:

• DB server running in Domain A

• SQL Client running on a server in Domain B - runs a transaction that would typically take 15 seconds to complete.

• Network connectivity breaks at 10th second between Domain A and Domain B

• SQL client displays error message - network failure

• Transaction not completed on the DB server. No records updated.

I believe you have to do this on application level and not on SQL Server.

Here is .NET way of inserting in to the event viewer: http://forums.asp.net/t/1503109.aspx/1

StackExchange Database Administrators Q#31106, answer score: 2