Timing out sql connections from VB
-
Happy Holidays!
My employer wanted to know if there is a way to disconnect a user after a certain period of time of inactivity and then send them a message saying that the connection has been terminated.
Thanks, Juanita
-
Probably find something in the script library that comes close. Just need a job that checks sysprocesses, then kills the spid if its too old. Have to leave out system spids. Notification depends on your environment. If you're using NT authentication you can look it up in Active Directory. Another option would be to net send to the host name.
Andy
-
Thank you very much Andy. I will look into the script library.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply