Need help

  • 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

  • 1. Have any "new" records been inserted into the RestoreHistory table since they database was restored?

    2. Try dropping and re-creating the trigger

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • yes when ever bkp restoring records are inserting

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply