Post reply

Timing out sql connections from VB

  • December 17, 2002 at 10:34 am

    #80088

    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

  • December 17, 2002 at 11:04 am

    #444616

    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

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

  • December 17, 2002 at 11:41 am

    #444618

    Thank you very much Andy. I will look into the script library.

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

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