Stopping automatic reconnect of SQL tools

Hi,

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!

[718 byte] By [DecaysChampion] at [2008-2-14]
# 1
There is not much you can do from stopping your clients to connect to database they have access to.
MichielWories at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...

SQL Server

Site Classified