Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-26 : 09:29:49
|
| Daire Cunningham writes "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,DaireSQL Server 2000, Server WinNT4, Client Win2k Pro" |
|
|
|
|
|
Context_info and session timeout