Post reply

Select Query blocks

  • January 6, 2003 at 1:28 am

    #58222

    hi,

    Got two select queries get blocked; when remove (kill the process) the process other queries work, what could be the reason as this queries work fine when run on query analyzer.

    Need urgently temporarily used nolock in select.

    Wrgds

    Ganesh.K

  • January 6, 2003 at 4:03 am

    #445590

    Usually blocking is due to one holding resources the other needs and vice versa. Make sure your queries access the data in the same order.

    For us to better understand if the issue is your order or order of execution thou can you please post both the statements plus anything specific they block constantly? I doubt it is just those two queries, something else has to be involved too.

    Edited by - antares686 on 01/06/2003 04:04:57 AM

Viewing 2 posts - 1 through 2 (of 2 total)

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