Imagine an earth quick happens and my coworkers can't log of their Management Studios, And some bad people like zambies, attack my office, and use their logged in sessions to steal data. so i have to kill idle sessions automatically, and force users to login again. — mehdy14 mins ago
some people have lot of spare time
If both zombies and earth quick (sic) hit me, the least of my worries would be data loss.
I kill user sessions, in activity monitor, but still users who was logged in by Management Studio, after click new query, they have new session!
I want to kill sleep sessions periodically during a day, but Management Studio saves their credentials, how can I do it?
SO has much more questions from users not completely educated about the way the network works. Can you seriously expect SO veteran users suggesting a question be migrated to waste their precious seconds on informing the poor OP of all the fine points regarding the process?
@ypercubeᵀᴹ Yeah just a normal move to trash. Message removed, replaced by later "message moved to Trash" message which can be edited. Net effect: relocation.
@JoeObbish I think we all did. The transcript is very entertaining reading though
On the trigger question: I only saw it because I was processing a flag. The answer was obvious and I didn't even bother to read what the trigger code was doing. Please feel free to cover that in a separate answer. Or direct them to Code Review SE maybe.