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,