We would like to automatically block or kill other processes using a set
of databases. We want to do this at very infrequent times where the
entire data in these databases are going to be converted.
Unfortunately the connected workstations are widespread and often, the
users do not end the connected applications. So we want to be able to
kill their process in SQL server.
We have tried creating a process which uses the KILL command in T-SQL,
but it will not permit a variable to be used. IE "KILL 10" works but
For operational reasons, we cannot have a manual process (IE The SQL
Enterprise Manager) kill the processes manually. This procedure needs to
Does anywone have an Idea of how we can termminate database connections,
or how we can use the KILL command with a variable?