Stopping automatic reconnect of SQL tools
I've developed a tsql alert response stored proc. that will kill connections from specified developers if they connect to particular dbs using tools other than ones they are authorized to have. It seems to work well for most applications like Excel and Access, but not for Query Analyzer and Enterprise Manager because the latter immediately reconnect after their session is killed. Is there any way to stop this behavior from the server side? I know I can use sp_denylogin to kill their login account, but that seems a bit much, esp since the proc could be triggered accidentally by mousing over a prohibited db in Enterprise Manager. It also doesn't help for SQL logins.
Any help would be appreciated!

