SQL Server session timeout period?

  • Daire Cunningham

    SSC Enthusiast

    Points: 112

    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

  • This was removed by the editor as SPAM

  • Key DBA

    SSCertifiable

    Points: 6029

    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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply