Weird parallel stored procedures execution problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dominic (Dominic_at_discussions.microsoft.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 02:23:01 -0700

Hi

We have a weird problem with our SQL Server 2000 Enterprise Edition SP3a.

We have several parallel running procedures. They are using Cursors (always declared as local), Temp tables, User Defined Functions and so on….

Now we have under some circumstances the problem, that some of the SP’s are stopping suddenly without any error message.

Any suggestions? I’m grateful for every hint ….

Regards,
Dominic

Relevant Pages

  • Weird parallel stored procedures execution problem
    ... We have a weird problem with our SQL Server 2000 Enterprise Edition SP3a. ... We have several parallel running procedures. ... They are using Cursors, Temp tables, User Defined Functions and so on…. ...
    (microsoft.public.sqlserver.server)
  • Weird parallel stored procedures execution problem
    ... What are your locking / isolation levels? ... >We have a weird problem with our SQL Server 2000 ... Enterprise Edition SP3a. ... >We have several parallel running procedures. ...
    (microsoft.public.sqlserver.server)
  • Re: Cursors
    ... Assuming you refer to WHILE loops in SQL Server vs. a cursor in SQL Server, i.e., all back-end programming: ... As for ANSI SQL compliance, SQL Server added to the DECLARE CURSOR support for the ANSI SQL 92 standard in ... So, yes, cursors are in ANSI SQL. ...
    (microsoft.public.sqlserver.server)
  • Re: Row by Row Operations Help req
    ... No cursor or row by row loop on large amounts of data in SQL Server is going to be efficient (and loops embedded in loops or cursors embedded in cursors is even worse). ... You rightly said that doing row by row operations in different manner is just like using cursors, I am into the same situation where I need to do row by row processing.I had created a temp table and looped it.In fact, I had two temp tables and two loops i.e nesting of loops I am doing.To explore below is the structure of my Store Proc ...
    (microsoft.public.sqlserver.programming)
  • Re: Fujitsu cobol and SQLServer
    ... "Steve Rainbird" wrote in ... Server side cursors with SQL Server are not a good idea and are best avoided. ... Fujitsu assumes last connection until/unless you use SET CONNECTION. ... With microfocus cobol I never had this problem (true it is 4 or 5 yesrs since I used Mf and SQL server I tend to use Oracle). ...
    (comp.lang.cobol)