http://technet.microsoft.com/en-us/library/cc748841.aspx

A trigger tied to on disconnect from user session may do what you need.