Show how tables are accessed by stored procedures

msqmsq Posts: 7
edited July 24, 2006 4:00AM in SQL Dependency Tracker
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.

Comments

  • 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.
Sign In or Register to comment.