Does anyone have code to kill all current database connections prior to a restore (SQL 2005)? Perhaps by utilizing dm_exec_requests?? This was a fairly straightforward bit of coding in 2000 (via sysprocesses table) but is counfounding me in 2005....many thanks!