InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:23:43 GMT20http://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspx[quote][b]Markus (2/14/2011)[/b][hr]Some applications create a connection to the db and stay idle and connected to the db. That way when data is requested it simply reuses that idle connection. Killing them defeats that purpose and will fill up your SQL Server log with killed connections.[/quote]And may cause application errors if the application is not set to handle connections that it thinks are open but are not.Mon, 14 Feb 2011 08:40:36 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspxSome applications create a connection to the db and stay idle and connected to the db. That way when data is requested it simply reuses that idle connection. Killing them defeats that purpose and will fill up your SQL Server log with killed connections.Mon, 14 Feb 2011 08:29:56 GMTMarkushttp://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspx[quote][b]Charlie.anna (2/10/2011)[/b][hr]Its just a requirement, i hope by doing this i will not break any law :unsure:[/quote]I'm asking because there are very few good reasons to do this and if you do all your application have to be able to deal with connections that they think are open being closed underneath them, transactions being rolled back that should have been committed, etc.May I suggest you go to the person who requested this and find out more information on why?Thu, 10 Feb 2011 07:11:45 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspx@GilaMonsterIts just a requirement, i hope by doing this i will not break any law :unsure:Thu, 10 Feb 2011 06:53:20 GMTCharlie.annahttp://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspx@Abhijit MoreI am not an advance user, just a programmer so would you please describe :-)Thu, 10 Feb 2011 06:51:57 GMTCharlie.annahttp://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspx[quote][b]Charlie.anna (2/10/2011)[/b][hr]I want to automatically logout the inactive users from sql server 2005/2008 after certain time limit(ie. after 5minute).[/quote]Why?Thu, 10 Feb 2011 05:58:14 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspxyou can leaverage the dynamic management view to check the inactive users.Thu, 10 Feb 2011 04:22:15 GMTAbhijit Morehttp://www.sqlservercentral.com/Forums/Topic1061834-1292-1.aspxHello all,I want to automatically logout the inactive users from sql server 2005/2008 after certain time limit(ie. after 5minute).Is there anyway to do so by management studio or some script?Need your help!Regards,CharlieThu, 10 Feb 2011 04:06:43 GMTCharlie.anna