I’m getting a SQL Server error:
Execution fail against sql server. Sql error number: 1236. Error
Message: A transport-level error has occurred when receiving results
from the server. (provider: TCP Provider, error: 0 – The network
connection was aborted by the local system.)
This occurs when I execute a stored procedure.
The stored procedure has worked well for some months. Some days ago, we moved the database to another server and get this error.
I use this proc in an ADF pine-line, and sometimes I get this error, not always but very often.
I try to remote to the server and execute directly from SSMS but the error still happens.
I have tried to research in many forums, but there is no solution that fixed my case.
How can I resolve this? Any idea? Thanks