We walk in the dark places no others will enter
We stand on the bridge and no one may pass

select * into #sp from sys.sysprocesses;
declare @spid int = 0;
while @spid >= 0
begin;
   select @spid = min(spid) from #sp where spid > @spid;
   if @@rowcount >= 1
   begin;
      select * from #sp where spid = @spid;
      dbcc inputbuffer( @spid );
   end else break;
end;

SELECT deqs.last_execution_time, dest.TEXT AS [Query], *
 FROM sys.dm_exec_query_stats AS deqs
 CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
 WHERE dest.TEXT like '%DROP%'
 ORDER BY deqs.last_execution_time DESC;