Post reply

Need help

  • February 9, 2014 at 3:02 am

    #304105

    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

  • February 9, 2014 at 9:41 am

    #1687374

    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

  • February 10, 2014 at 10:22 am

    #1687620

    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