Show how tables are accessed by stored procedures

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Show how tables are accessed by stored procedures

Postby msq » Fri Jul 21, 2006 12:47 pm

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.
msq
 
Posts: 4
Joined: Thu Jul 20, 2006 3:54 pm

Postby wallacea » Mon Jul 24, 2006 9:00 am

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.
wallacea
 
Posts: 29
Joined: Tue Dec 06, 2005 4:42 pm
Location: Red Gate


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests