Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-01 : 07:36:43
|
| Eric writes "I currently am running some stored procedures at night, but all of a sudden they have been failing over the past week. The procedures run fine in Query Analayzer, but not in the Server agent. I have a dual p4 2.4 xeon w/ 2gb of ram and I checked the server load and it was nothing to be worried about. This is the error I get...Executed as user: sa. ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.I would appreciate any help with this matter and thanks in advance.eric" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-01 : 08:21:24
|
| Are you running these procedures cross-server using OPENROWSET or linked server? Also, have you looked in the error logs for SQL and the server error logs to see if there are any other network errors?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
ConnectionRead (WrapperRead()) General Network Error