Discussion in 'SQL Server 2005 General DBA Questions' started by CanadaDBA, Sep 11, 2008.
Does only running a SELECT statemnet updates Last_Batch in master.dbo.sysprocesses?
Well, I found this: http://technet.microsoft.com/en-ca/cc825503.aspx
I want to detect if a connection has been idle for more than 60 minutes. I have licnese limitation for an application and want to drop idle connections. What should I do to detect this status?
http://blogs.msdn.com/sql_protocols/archive/2006/03/09/546852.aspx on your keep-alive information.Coming to auto-disconnect SQL Server has no such need, and because of that applications rarely handle the disconnect well. Unless your application will benefit from this and is specifically written to tolerate the disconnection behavior that Oracle needs, I would avoid the temptation to interfere.
Separate names with a comma.