I have at many times had processes that are impossible to kill with the kill cmd in query analyzer, there fore I have to down the server. I have heard the Windows NT resource kit also has a kill command that you can use to terminate your connection from the SQL server at the dos cmd prompt. Is any one familiar with this? If so what could you please explain how it works. Thanks