1. jsgjoshua New Member

   I am running a DTS with a execute sql task. Task having I am calling a proc. This proc is running long. I am able to find it is running abnormal with lot of self locks.
   Any solution..
   

   jsgjoshua, Dec 4, 2008

   #2
2. rohit2900 Member

   Welcome to the Forums....!!!
   Can you post the code of the proc.
   How did you got to know that its running abnormal with lot of self locks?
   

   rohit2900, Dec 4, 2008

   #3
3. satya Moderator

   True, are you running SELECT * from <Tablename> on that task?
   If not check what kind indexes on that table which is involved in this task.
   

   satya, Dec 7, 2008

   #4

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