• Like today, within SSMS Object Explorer, you can right click on a stored procedure, table, view, etc. and select 'View Dependencies'.

    Still there are occasions where it's useful to query the underlying system views directly. For example, you may want to leverage sp_MsForEachDB and sp_MsForEachTable to quickly identify every object globally that references a specific table.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho