Re: stored procedure timeout 18:12:26

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

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 10/17/04 

Date: Sun, 17 Oct 2004 23:21:54 +0200

Hi

That works out to 65546 seconds, or very close to the limit of an unsigned
16 bit integer.

You may want to take it up with Microsoft PSS (.Net issue) if this is a
known limitation. 

-- 
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
message news:ODUpJmBtEHA.3788@TK2MSFTNGP15.phx.gbl...
> Al,
>
> You should start investigating by uing the Profiler. Trace stored
procedures
> execution, but trace statements inside the procedure as well, and you
should
> find the pint where te execution stops.
>
> -- 
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
> "al" <news@13c-thispartisfake.com> wrote in message
> news:uoHHG$%23sEHA.3772@TK2MSFTNGP10.phx.gbl...
> > I have a .net program that calls a stored procedure that times out
exactly
> > at 18 hrs 12 min and 26 seconds the last 2 times i ran it. This cannot
be
> a
> > coincidence - the usage of other processes on the machine varied. Lets
not
> > get into the rewrite it thing - I know I have to:
> > It is a looping proc executing other procs and for some reason the data
> for
> > this task is much larger than usual.
> >
> > I am extremely curious as to the meaning of this magic number. 18:12:26
> >
> > al
> >
> >
>
>

Relevant Pages

  • Re: VC++ 2005 beta1 fails with pthreads benchmark tests
    ... >> then it compiles and passes all the benchmark tests in the ... >> tests fail in execution: ... >> Why are there such differences in execution of the generated code ... Setting environment for using Microsoft Visual Studio 2005 tools. ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Job owned by a non-sysadmin fails to run
    ... You mentioned earlier that you looked at the job for error messages. ... This could be due to a different environment or the way the program retrieves configuration information under the different execution contexts. ... SQL Server MVP ... this executable runs fine if I login interactively as user as well as sqlproxy and execute it from the command line. ...
    (microsoft.public.sqlserver.security)
  • Re: Job owned by a non-sysadmin fails to run
    ... redirecting stdout/stderr to a file using on the command line: ... execution contexts. ... SQL Server MVP ... Mapped drives are not accessed. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Media Player executes WMF content in .MP3 files.
    ... >>execution, will ask the kernel to do the exec. ... and never on the filename. ... In the Microsoft world, sometimes the filename counts, sometimes a magic ...
    (comp.security.misc)
  • [Full-disclosure] Microsoft Windows file open without extension
    ... Microsoft Windows usually recognizes files by their extensions. ... victim would have to rename the file before execution (from backdoor.lol ... I deleted the extension of some well-known files. ... Altought this is limiting the attack possibilities some of them are ...
    (Full-Disclosure)