Hi,
we have "old" application that after SQL server instance installation runs 100+ sql scripts and create server triggers, several db(s), add objects to those db(s)
Goal: Document name and sequence of execution of all the scripts.
We can only use native SQL server tools and PowerShell.
My first choice would be SQL Profiler.
Problem
1.SQL scripts might contain code for creation of more then 1 object so I can't compare script name to object created
2.Not sure if any standard SQL profiler event can capture name of the SQL script executed .
Thank you
Alex