CREATE PROCEDURE sp_Clear_DB (@db_Name varchar(100)) AS
declare @spid int
declare @sql varchar(100)
declare cur_Processes cursor for
select
p.spid
from sysprocesses p
inner join sysdatabases d on p.dbid = d.dbid
where d.Name=@db_Name
open cur_Processes
fetch next from cur_Processes into @spid
while @@fetch_status=0
begin
set @sql='kill '+convert(varchar(100), @spid)
exec(@sql)
--print @spid
fetch next from cur_Processes into @spid
end
close cur_Processes
deallocate cur_Processes

Не было дня, что бы я не заходил на www.sql.ru (the best one!!!). Что грустный - это да. Хуже нет - быть грустным
без причины.
Сегодня - 90 лет со дня рождения Алана Тьюринга, одного
из тех, благодаря которым сидим мы за клавами, а не за
абаками. К сожалению, дёрнул его черт податься в секс-
меньшинства. И вот его конец (трагический или драматический - не знаю):
He was found by his cleaner when she came in on 8 June 1954. He had died the day before of cyanide poisoning, a half-eaten apple beside his bed. His mother believed he had accidentally ingested cyanide from his fingers after an amateur chemistry experiment, but it is more credible that he had successfully contrived his death to allow her alone to believe this. The coroner's verdict was suicide.
_______________________________________
R.I.P.