I am getting the abovementioned problem when I am running long queries
(about 500 odd records) and have internal logic this is complex i.e. (while
cursors are open I am doing some lengthy internal processing on the data).
The same logic is exected for other sets of tables and run fine as they have
less than a hundred records.
Does anyone know, or can anyone please advice me as to what to look for to
fix this problem.
The message on the NT server states:
Error: 17824, Severity: 10, State:0
Unable to write to ListenOn connection 'SHSC_SQLDEV1', loginname
OS Error: 64, The specified network name is no longer available.
Thanks in advance.