Refer to attached SQL script: I may run it in scheduled batch mode (in case it takes too
long & my Rdp session into SQL Management Studio drops/disconnects).
The database of 90GB (& another one to be done next month is 550GB) is rather
large & the script may take very long (or possibly 'hangs').
Is there a way (using sql command or tools or SQL Mgmt Studio) to track its progress
(say how much has been updated, how many more to go or in terms of % completion ? )
I'm not a DBA & not MS SQL trained, just a sysadmin running blindly from Management studio,
so appreciate a layman's step by step instruction
Just checking if there's IO activity is not good enough