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

Mur1en

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.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]