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