SQL Server session timeout period?

• Daire Cunningham

  SSC Enthusiast

  Points: 112

  More actions

  April 19, 2006 at 10:29 am

  #68788

  Hi there.

  I have a VB.net application that uses SQL Server triggers to create an audit trail whenever data in my tables change. I track the current user of my app by setting the context_info of my SPID with the logged in username (stored in my User table) and fetch this back when writing the audit record. This works fine until the user has been logged in for about 6min 20s after which the session logs itself out and I've lost the context_info record.

  My question is, where or how is this session timeout set? If I can't prolong it I'll have to come up with a different idea for the audit trail as I don't want to keep the connections open idenfinitely.

  Thanks in advance,

  Daire

• April 24, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Key DBA

  SSCertifiable

  Points: 6029

  More actions

  April 29, 2008 at 6:26 am

  #808273

  Daire,

  What exact error syntax is SQL Server giving you?

  This may help:

  SQL Server 2005 Books Online (September 2007)

  Troubleshooting: Timeout expired

  http://msdn2.microsoft.com/en-us/library/ms190181.aspx

  "Key"
  MCITP: DBA, MCSE, MCTS: SQL 2005, OCP