MSSQL: Kill a block process/ Cancel a running SSIS package
0Hancock posted on 2025/02/12 16:25:34
Kill a block process:
declare @id int
select @id = spid from master.dbo.sysprocesses
where blocked = 1
kill @id;
Cancel a running SSIS package:
declare @id int
select @id = execution_id from catalog.executions Where end_time is null
Exec catalog.stop_operation @operation_id = @id
