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.

Best Answer

  • Alex BAlex B Posts: 955 Diamond 3
    Accepted Answer
    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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • 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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • JimFJimF Posts: 49 Bronze 3
    @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?

Sign In or Register to comment.