SQL Dependency Tracker - 2.7
Selecting objects - SQL Dependency Tracker
When you are analyzing and customizing the dependency diagram, you will need to select objects.
Selecting an object in the Diagram pane also selects it in the Objects in Project pane. The object and its first-level dependencies are highlighted in the diagram. A full, hierarchical list of the dependencies is shown in the Dependencies pane.
Similarly, selecting a visible object in the Objects in Project pane also selects the object in the Diagram pane and displays its dependencies in the Dependencies pane. If appropriate, the diagram is panned and zoomed so that all the (unhidden) selected objects are shown. Selecting a hidden object only displays its dependencies in the Dependencies pane.
The following selection features are provided on the toolbar:
- To select all objects shown in the diagram, click
All - To select all objects that are directly connected to the selected objects on the diagram, click
Connected ObjectsThis is not available if no objects are selected.
- To reverse the current selection, so that selected objects are cleared, and unselected objects are selected, click
InvertThis is not available if no objects are selected.
- To clear the object selection, click
NoneThis is not available if no objects are selected.
To access these toolbar selection features directly from the diagram, right-click an object, click Select, and then click the option you require.
To access these selection features from the Objects in Project pane, right-click, click Select, and then click the option you require. Note that if you select All or Invert, objects that are not shown in the diagram are not selected in the list.
Some further selection features are provided on the menus:
- To select all objects that are the same object type:
- in the diagram, right-click an object of that object type, click Select, and then click Same Type
- in the Objects in Project pane, click the menu to the right of the
filter text box, and click the object type
- To select all objects with the same owner, in the diagram right-click an object with that owner, click Select, and then click Same Owner
- To select all objects that belong to the same database, in the diagram right-click an object from that database, click Select, and then click Same Database
- To select all objects that have no connection to any other object shown on the diagram, in the diagram right- click an object, click Select, and then click Independent Objects
You can use this feature to find objects that have no dependencies. To do this:
- add all the objects to the diagram
- ensure that there are no hidden objects
- ensure
Filegroup and System Object Dependencies is selected - ensure
Constraints as Objects is selected - in the diagram right-click an object, click Select, and then click Independent Objects
See also |
Was this article helpful?
Using SQL Dependency TrackerSQL Dependency Tracker
- System.TypeInitializationException on launch (version 2.2)
- Description of the relative importance bar
- Add objects to project option greyed out
- Connections to servers timing out
- SQL Dependency Tracker has encountered an unexpected condition
- SQL Dependency Tracker permissions
- PDF report output running past the bottom of the page
- File or assembly name vjslib not found
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Dependency Tracker
- Activating your products
- Activating your products
- Getting help offline
- SQL Dependency Tracker release notes - version 2.xx
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
