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)))
Log in trigger
- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 3771
One my example how to log messages in trigger.
Create table: