Kill Idle Sessions

Mike_B

An issue has arisen with database logins. Users are loggining on to the system but not logging out when not using the system.

This is causing other users not being able to logon as all the licences have been allocated.

Is there anyway of logging the idle users off the system automatically after a set period of time to include running reports.

Is there a serverside script that will do this as we are running SQL2000.

Savatage

there are a bunch of posts about killing session and/or limiting the # of times someone can log in.

You can use the search of the forum for "Sessions".

Kill Idle Navision Sessions (SQL scripts)
http://www.mibuso.com/dlinfo.asp?FileID=367

Another post is this "Session Killer":
http://www.mibuso.com/dlinfo.asp?FileID=71

kine

You can create such a "Teminator" directly in Navision. In session table there is IdleTime, you create only some timer which will check this and sessions with IdleTime > limit will be deleted from the session table (it will do Kill on the MS SQL)