Options

How can i set idle time everywhere? (Kill Session) - (Multiple User Connection)

Mur1enMur1en Member Posts: 3
edited 2016-02-16 in NAV Three Tier
I see some solution for kill session. I want kill session multiple option. Please write each solution with work versions both of Navision - SQL and Native DB.

Someone said to
Change registry "KeepAliveTime" DWord
Another one
go to table 91 and create new field name of "Kill Idle Duration" and type Duration then value to 50000
and new one write code for Navision Codeunit ;
BEGIN 
      Session.SETRANGE("My Session",FALSE); 
      Session.SETFILTER("Idle Time",'>15 min'); 
      IF Session.FINDSET THEN REPEAT 
        Session.DELETE; 
        COMMIT; 
      UNTIL Session.NEXT = 0; 
    END;
,,, SQL Scripts for SQL Server or Codeunit for Native DB
I see too much solution for this problem but i need new one. One code all version that is my target. Thanks a lot.

Answers

Sign In or Register to comment.