用触发器追踪到底是哪个存储过程删了数据

create table students(
   id integer primary key, 
   name varchar(20), 
   age int
);
insert into students values(1, ‘Flower‘, 18);
insert into students values(2, ‘John‘, 19);
insert into students values(3, ‘Jeff‘, 17);

create procedure del_student @del_id integer
as
begin
   delete from tosska.dbo.students where id =@del_id;
end;

create trigger students_delete
on students
after delete
as
declare @info nvarchar(4000);
declare @source table (EventType nvarchar(30), Parameters int, EventInfo nvarchar(4000));
begin
  if object_id(N‘tosska.dbo.log_students‘, N‘U‘) is null
     create table tosska.dbo.log_students(spid int, log_time datetime, application nvarchar(128), info varchar(4000)); 
  insert into @source exec (‘dbcc inputbuffer (‘ + @@spid + ‘) with no_infomsgs‘);
  select top 1 @info = EventInfo from @source;
  insert into tosska.dbo.log_students values(@@spid, getdate(), app_name(), @info);
end;

exec dbo.del_student 1;