SQLTeam.com | Weblogs | Forums

How can I see all the scripts in a SQL server?


In a SQL server, how can I see the scripts that run on imported data which result in the available tables and views?

From what I understand, the DBA imports some tables 'manually' i.e. from the cloud. They then somehow transform that data through various layers and they produce several other tables based on the originally inserted tables.

I want to see the whole transformation journey. Is that possible?


I would ask the DBA.. It sounds like a typical ETL process with SSIS

If you want to see all of the objects related to a specific 'string' value (e.g. a table name) - download and install SQL Search from Redgate.

Using that utility - you can then search all databases for a particular string value and find all tables, views, procedures, functions, etc... that have that string value.