Post reply

Finding DROPPED Trigger

  • April 10, 2013 at 5:23 am

    #270947

    Hi Team,

    I've 100 of triggers in my database, today i found that some triggers are dropped from my database.

    How to find the dropped trigger names.

    Please help me...

  • April 10, 2013 at 6:25 am

    #1605185

    Hopefully you have sourcecode control - that would be one place. you could look for these triggers in your stored backups by restoring the db somewhere else or as a different name.

  • April 10, 2013 at 6:27 am

    #1605186

    if not too much time has passed, they may still be in the default trace;

    there's a built in report that filters by database in SSMS:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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