Hi All,
i am creating Trigger in MSDB as mentioned below
but after restoring the db Trigger not firing ,no records are inserting in Temp table
please let me know wat is the issue or else any alternative solution
create trigger TRG_restore
on restorehistory
after insert
as
insert into Temp(DBname) select destination_database_name from inserted
thanks