Trigger object do not show uses info

[mstanl]

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

[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

[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