I am running a sproc on an SQL Server 2005 server which is resulting in the following error:
Msg 64, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Once the error occurs I loose my connection to the server, but able to reconnect.
There is nothing in the Event logs.
The database is still functional and running its website fine.
EDIT: This occurs every time I run this sproc, or it's called by an application.
Any suggestions on what may be causing this error?