Show how tables are accessed by stored procedures
msq
Posts: 7
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.
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
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.