RE: Download SQL patch Info – SQLServerCentral

SSC-Insane

Points: 24689

July 5, 2017 at 11:08 am

#1949539

christoffersen366 - Wednesday, July 5, 2017 8:16 AM
Nice project. But I'm not getting anything in the @html variable, the html file is empty. It can reach the site and I've tried another path without spaces with same result and changing the link and still nothing.

I had that at first too. Is your wget set up properly? you need 3 files for it to work properly: the wget.exe and 2 dll's.

I have this working in one of our test instances and am now building up a stored procedure that goes out and queries all of the other servers to see what version they are on and then builds up a result to indicate if I am behind or not.
On the test systems, most of mine are a little bit behind, but not terrible.

Thanks a bunch for the script!

The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.