Re: Weird parallel stored procedures execution problem

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 09:18:23 -0400

Have you run profiler with errors and assertions events turned on? When you
say stopped what exactly do you mean? Are they just blocked or hung, do you
get disconnected or what? 

-- 
Andrew J. Kelly  SQL MVP
"Dominic" <Dominic@discussions.microsoft.com> wrote in message
news:A7A0B99F-B65D-49D4-9AF4-A0CBED472B23@microsoft.com...
> 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

  • Re: GRUB loader hangs in to message "savedefault" in Debian etch and load error in Ubuntu.
    ... and it gets hung up. ... of the default configuration for GRUB on Debian. ... leading up to it and the text of the error message), ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: Monitoring Impact of a User in SQL Server
    ... At least it will be read only but they can still issue any queries they want. ... Profiler or Trace will allow you to see what each connection is doing. ... Andrew J. Kelly SQL MVP ... I didnt actually realise SQL Server had ...
    (microsoft.public.sqlserver.tools)
  • Entourage stalls on sending - receiving OK
    ... Three people in our office and at home are running Entourage and the same ... anomaly will frequently occur - it will simply get hung up when sending ... error message that says it can't connect to the server. ...
    (microsoft.public.mac.office.entourage)
  • This request requires HTTP authentication ().
    ... hung up on the Mapping URLs to Web Component section. ... get an error message: This request requires HTTP authentication. ...
    (comp.lang.java.help)
  • Re: SQL Losing Data
    ... >> I've tried using Profiler in the past and found it a bit unwieldy. ... > connect to the server. ... You may recognise an update statement or ... > error message then this means that Access did actually try to save the ...
    (microsoft.public.sqlserver.odbc)