Is there a configurable parameter in SQL Server 2000 that can be set to disconnect an inactive application login after certain time frame (e.g. 30 mins)?
There isn't a way. I've written jobs that ran every 5 minutes and killed things. If you look at sp_who2, there is a last_batch column, which is the last time the connection sent something to the server. You can use that to kill connections.