Sql Server - analyze sql script changes on a Database
0
votes
1
answer
154
views
Need your insights. Thank you for taking time and sharing.
**Context**
We have a 10 sql scripts which has more than 10000 lines of code and most of them are scripts and some code in each script are irrelevant
**Problem**
I need to identify which scripts and which parts of the script actually being applied on the DB so that we can re-structure the scripts . I at least need to share stats for my safety. I don't have any idea how to start
- DML operations
- DDL operations
- Deadlocks
I'm a junior DBA never had done this activity and I don't what compelled them to push it to me. May be I'm asking too much kindly at least push me in right direction so I can start somewhere.
Asked by Shadow777
(1 rep)
Aug 12, 2024, 05:13 AM
Last activity: Jul 20, 2025, 09:06 PM
Last activity: Jul 20, 2025, 09:06 PM