By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,068 Members | 874 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,068 IT Pros & Developers. It's quick & easy.

Stored procedure fails execution sometime

P: n/a
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)

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.