Hi All,
I have stored proc that processes about 60,000 rows using a cursor. When I call the SP from Query Analyzer, I get the following error message after processing about 12,000 records :
Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
ODBC: Msg 0, Level 16, State 1
Communication link failure
Connection Broken
12614 records
What can i do to make this SP run sucessfully ? I even tried using a table variable instead of a cursor, but got the same result.
THE output from SP_CONFIG is
Option config_value
---------------------------------------
affinity mask | 0 |
allow updates | 0 |
awe enabled | 0 |
c2 audit mode | 0 |
cost threshold for parallelism | 5 |
Cross DB Ownership Chaining | 0 |
cursor threshold | -1 |
default full-text language | 1033 |
default language | 0 |
fill factor (%) | 0 |
index create memory (KB) | 0 |
lightweight pooling | 0 |
locks | 0 |
max degree of parallelism | 0 |
max server memory (MB) | 2147483647 |
max text repl size (B) | 65536 |
max worker threads | 255 |
media retention | 0 |
min memory per query (KB) | 1024 |
min server memory (MB) | 0 |
nested triggers | 1 |
network packet size (B) | 4096 |
open objects | 0 |
priority boost | 0 |
query governor cost limit | 0 |
query wait (s) | -1 |
recovery interval (min) | 0 |
remote access | 1 |
remote login timeout (s) | 20 |
remote proc trans | 0 |
remote query timeout (s) | 0 |
scan for startup procs | 0 |
set working set size | 0 |
show advanced options | 1 |
two digit year cutoff | 2049 |
user connections | 0 |
user options | 0 |
No comments:
Post a Comment