New features added to SQL Prompt Watch now.

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 6.6.0.101.
· Share on Twitter

Comments

  • 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?

    Thanks,
    Aaron.
    · Share on Twitter
  • jeffglazierjeffglazier Posts: 3
    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.

    Best,
    Jeff
    · Share on Twitter
Sign In or Register to comment.