What are the challenges you face when working across database platforms? Take the survey

Find Invalid Objects / DML Triggers

jeffglazierjeffglazier Posts: 3
edited June 1, 2015 9:53PM in SQL Prompt
Find Invalid Objects doesn't seem to be analyzing DML (i.e., table) triggers. When I move a table to a different schema and then run the Find Invalid Objects command to make sure nothing broke as a result, it doesn't list any DML triggers that broke as a result of the change.

I'm using SQL Prompt version


  • Options
    Aaron LAaron L Posts: 596 New member
    Hi Jeff,

    Prompt should be scanning DML triggers (I just gave it a test on a trigger using a missing column) however it might not be testing for the error you're seeing. Would you be able to provide some steps for how to recreate the error?

  • Options
    Hi Aaron,

    Sorry, I just noticed your reply right now. Coincidentally, it seems to be working fine today. Might have just been a hiccup in SSMS when I tried it the other day. Sorry for the mistaken bug report.

Sign In or Register to comment.