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

Trigger object do not show uses info

Why do trigger objects not displayed "used" in the db or "uses by" information in the doc tool?

I need to lookup and change a table in all places in a database but the tool will not display a table if only used in a trigger.

It would be nice to find an object in all programming in a SQL database, I do consider a trigger to be a programming object.

Thanks
Mike
mstanl
0

Comments

2 comments

Sort by
  • David Atkinson
    Thanks for pointing this out.

    SSMS has a View Dependencies feature (right click in object explorer) that may help you find references to your object.

    Alternatively, you could use SQL Search http://www.red-gate.com/products/SQL_Search/ (a free tool).

    Regards

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • mstanl
    Thank you for the reply

    Problem with "SSMS has a View Dependencies feature" will not cross over to other databases.

    Redgate search works ok but it includes comments in its display so it is not 100% correct.

    But thanks
    Mike
    mstanl
    0

Add comment

Please sign in to leave a comment.