Hi, Got a problem with a stored

[LokiDba]

Hi,

Got a problem with a stored procedure on v7.0. when I run the procedure, it takes about 15mins to complete, I get the following error message:

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

Connection Broken

Searching through forums etc. It sounds like its a problem with SQLServer and the Cursor in this stored procedure. Does any one know a fix or a work around for this problem.

Thanks in advance

LokiDBA.

 

[Cagliostro]

As I believe, your cursor make procedre too slow.
Do not use cursors in passthrough queries. At the first select data what you need, and after do with it what do you want on your computer. After it, only send back modified data. John Fill

 

[LokiDba]

This is a batch process so all the work has to be in the stored procedure because it can be run be both VB and Query Analyser. We have had the problem through both tools but it is intermitant.

When VB calls it, its just calling a top level sp.

Thanks for the Help

Any other suggestions?

LokiDBA