What, When, Where, How, Who2
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
I am trying to zip some files with an unknown file type individually. I am using the following code in a batch script to do that:
@ECHO OFF
FOR %%A IN (bestbuy*nat*component.cpi*) DO "C:\Program Files\7-Zip\7z.exe" a -mx9 -m0=lzma2:d256m "%%~nA.7z" "%%A"
The code will compress files individually ONLY if the file has an extension. Unfortunately…
