The victim of my carnage being a connection to the SQL Server 2005. How many times have you issued a query that you had no idea how long it would run, just to loose your patience after 10 minutes and rolled it back, forgetting that it'll probably take 10+ minutes to rollback anyway? Come on don't be shy... raise your hand... I know you're one of them :) Although there is no way to get the rollback time from the ROLLBACK command (if there is do let me know) we can use an extended way of calling the KILL...