Red Gate forums :: View topic - Trigger object do not show uses info
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 2
SQL Doc 2 forum

Trigger object do not show uses info

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
mstanl



Joined: 30 Jan 2009
Posts: 3

PostPosted: Thu Dec 09, 2010 6:32 pm    Post subject: Trigger object do not show uses info Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1108

PostPosted: Fri Dec 10, 2010 12:51 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
mstanl



Joined: 30 Jan 2009
Posts: 3

PostPosted: Fri Dec 10, 2010 3:11 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group