How can we help you today? How can we help you today?

Using SQL Dependency Tracker from SSMS—TMI

I would like to know if I am missing a setting somewhere for the SQL Dependency Tracker.

I would like to use Dependency Tracker from inside of SSMS, but at it works now, it's too noisy. I would like to find an object in SSMS, right click on it, and choose "View Dependency Diagram for …" and not get a diagram of my entire database. For me, that's useless. I think the default for the application should be "Add object that the selected objects are used by 1 level" (see image below), but it defaults to All levels and I can't seem to set an application default for this dialog box, only after a project is open and at that point, it's too late—the entire database has already been added.

It's easy to add more layers to a Dependency Diagram, but not so easy to remove items in a smart way—that's why I wanted a simple diagram in the first place, to find out what uses this object directly, not indirectly.



JimF
0

Comments

3 comments

  • Alex B
    Hi @JimF,

    I've just checked this in the latest SQL Dependency Tracker 3 and the settings are saved in the file MyDefaults.xml located at "%AppData%\Red Gate\SQL Dependency Tracker 3" and applies when I use the right click context menu option from SSMS.

    Can you update to the latest version and see if it works for you there?

    Kind regards,
    Alex
    Alex B
    0
  • JimF
    @Alex B ,

    I don't have that folder. I do have "%AppData%\Red Gate\" and under that I have "SQL Data Generator", "SQL Multi Script 1", and "SQL Refactor", but not one for the Dependency Tracker.

    Where else would it be hiding?

    Thanks,
    Jim
    JimF
    0
  • Alex B
    Hi @JimF,

    Righto, so you have you opened SQL Dependency Tracker, populated some objects to it, then clicked Tools > Options > Diagram and selecte the option you want saved as a default and then clicked OK and actually save the project as a specific file somewhere. 

    Once you save the project, the file is created/modified.

    Kind regards,
    Alex
    Alex B
    0

Add comment

Please sign in to leave a comment.