Red Gate forums :: View topic - Show how tables are accessed by stored procedures
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Show how tables are accessed by stored procedures

 Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
msq



Joined: 20 Jul 2006
Posts: 4
PostPosted: Fri Jul 21, 2006 12:47 pm    Post subject: Show how tables are accessed by stored procedures Reply with quote
I'm new to SQL Dependency Tracker, but I'm finding it incredibly useful already. However, is there any way of showing whether tables are being updated by another object or whether they are simply "select"ed from ?

I'm using it to build test plans for a series of stored procedures that we are migrating from SQL 7 to 2005, and it would make it much easier if I could see which tables are updated from viewing the Dependencies tree rather than having to look through the SQL Script for each proc. Thanks.
Back to top
View user's profile Send private message
wallacea



Joined: 06 Dec 2005
Posts: 29
Location: Red Gate
PostPosted: Mon Jul 24, 2006 9:00 am    Post subject: Reply with quote
Hi,

At the moment we don't have a way of showing you that information other than the sql scipt. It is something we'll be looking at doing in the future though.

Alan.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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