1. tolejar New Member

   Hi,
   I have a problem with one procedure stored in database. Sometimes when I run it, it goes normally. But 2 from 5 times it behaves as neverending. I logged it and I found out that first select command of procedure behave as neverending. I really don't know why is that.
   Pls help me
   tom[:'(]
   
   

   tolejar, Aug 16, 2007

   #2
2. satya Moderator

   Best to check the execution plan for that Stored procedure, also try to compile for an upto date plan storage to pick up next time it runs.
   

   satya, Aug 16, 2007

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in