Matar Sesión en Diferente Servidor SQL
He hecho una consulta SQL para matar todas las sesiones bloqueadas. declare @tbl table (sesid int) insert into @tbl select BlkBy from (SELECT spid,sp.[status],loginame [Login],hostname, blocked BlkBy,sd.name DBName, cmd Command,cpu CPUTime,physical_io DiskIO,last_batch LastBatch,[program_name] ProgramName FROM master.dbo.sysprocesses sp JOIN master.dbo.sysdatabases sd ON sp.dbid = sd.dbid ) as tbl where BlkBy <> . . . Read more