May 4, 2006 at 12:20 pm
Hi,
In one of my server, while excuting my procedure i'm getting the below mentioned error. I tried with both TCP/IP and NP. Also my server has latest Service Pack. But I'm getting the below error. Please guide me to resolve this.
Sometimes the SP will run for 12-13 minutes and sometimes it will error out after only 2 min but each time you will see the error below:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
Some additional info that might be helpful is that other procedures run fine but this procedure inserts several million rows and it accesses another db on the server.
Thanks
Jay
http://www.sqldbops.com
May 8, 2006 at 8:00 am
This was removed by the editor as SPAM
September 1, 2006 at 12:39 pm
I am getting the same error when I try to run one store procedure using a linked server on my test environment. My servers’ configurations are windows 2003 with SQL 2000 sp 4. (Both servers are identically)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
But the awkward situation is that on my dev environment this sp works really fine but this server has some different configuration ( windows 2000 with SQL 2000 sp 4) and the linked server are point to itself ( I don’t have 2 server for dev).
Does anyone know how to correct this problem?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply