Trigger object do not show uses info
mstanl
Posts: 5
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
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
Comments
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
Product Manager
Redgate Software
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