Post reply

Script Task hangs

  • August 20, 2008 at 9:34 am

    #860713

    Yup. It will event ually timeout with a deadlock error.

    You are reading from the variable while trying to write to it.

    Do it in two steps.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 20, 2008 at 9:56 am

    #860742

    Cheers Crispin - that's the prob

  • August 20, 2008 at 9:58 am

    #860745

    NP

    What surprises me was the lack of timeout or did you cancel it to quickly. I believe it is 30 second. (I guess I would have canceled it too)

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply