Depending on security, you'll have different levels of access to the source systems and databases

The 3 most useful options to explore exactly where the data you report on is stored are:
  1. Read Only access options
    • Old fashioned manual browsing and documentation approach
  2. Read/Write access
    • Analysing stored procedures, identifying core tables, testing fields with edits
  3. SQL Profiler and tracing
    • Full admin access

An in-depth discussion on these 3 options and other effective tools such as Redgate SQL Search and SSDT

(no tags)
The video is not available to view online.