Options

Table blocked

asieraiesasieraies Member Posts: 49
edited 2007-12-28 in SQL General
Hi,

I use Nav 4.0 + SP3 and SqlServer2005. One user run a proces that block a table a long time. Another user want to use this table and obtain an lock error. Can I force the second user to wait until the table will be no locked??

Thanks

Asier

Comments

  • Options
    kinekine Member Posts: 12,562
    You can use
    LOCKTIMEOUT(False);
    
    somewhere in the process where you want to disable timeouts.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.