Trigger object do not show uses info

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Trigger object do not show uses info

Postby mstanl » Thu Dec 09, 2010 6:32 pm

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
 
Posts: 3
Joined: Fri Jan 30, 2009 3:55 pm

Postby David Atkinson » Fri Dec 10, 2010 12:51 am

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby mstanl » Fri Dec 10, 2010 3:11 pm

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
 
Posts: 3
Joined: Fri Jan 30, 2009 3:55 pm


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 1 guest