Microsoft SQL Server forum - Stored procedure fails execution sometime

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Stored procedure fails execution sometime

tilak.negi@mind-infotech.com

2005-05-30, 3:23 am

Hi,

There is a stored procedure which runs through job.
It is calling to other stored procedure and other stored procedures are
calling to another .. so on (approx 12-15 sp in batch)

Problem:
Sometime it does not execute properly. (approx very rare... once in 500
execution or sometime on new site/database)

I want to know the reason for it.
If anybody have faced the similar problem.

Please tell the possible causes and possible solutions.

Thanks in Adv.
T.S.Negi
(MIND)

Simon Hayes

2005-05-30, 3:23 am

No idea - what does "does not execute properly" mean? What does the job
history show? You'll have to give some more information about any
errors, and it would also be useful to know what version of MSSQL you
have, what the stored procedures are doing etc.

Simon

Sponsored Links