create table log (tableName varchar(max), msg varchar(max))Log in trigger:
declare @xml XML set @xml = (select * from deleted for xml auto, elements ) insert into log(tableName, msg) values('deleted', cast(@xml as varchar(max)))
create table log (tableName varchar(max), msg varchar(max))Log in trigger:
declare @xml XML set @xml = (select * from deleted for xml auto, elements ) insert into log(tableName, msg) values('deleted', cast(@xml as varchar(max)))