Synchronize Record Link Tabble Version 5.0

Collo
Collo Member Posts: 12
edited 2008-09-05 in SQL General
Hi
We are having issues after upgrading to Version 5.0.
Have added "Record Link" permission as a new role and trying to synchronise logins (all and single login).

The problem is that the "Record Link" table is Blocked on SQL by all the users on the system.

The only way to perform a synchronise is when all users are logged off. Unfotunately this is unacceptable to our customer.

Any Ideas/experience with locking on this table?

Cheers

Comments

  • DenSter
    DenSter Member Posts: 8,307
    I'd suggest you change the security model to standard. It won't resolve any locking issues, but it will make it so you don't have any more problems synchronizing your logins.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories