How can we help you today? How can we help you today?

Find Invalid Objects / DML Triggers

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.
jeffglazier
0

Comments

2 comments

Sort by
  • Aaron L
    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.
    Aaron L
    0
  • jeffglazier
    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
    jeffglazier
    0

Add comment

Please sign in to leave a comment.