2. You will need to install the following:
It gave me bollocks about having to restart the server, I didn’t bother…
3. Download and extract the SQL Script here and save it to your C: drive.
4. Open a command prompt prompt as Administrator and change directory to the default sqlcmd directory. You can just copy and paste this:
cd C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn
5. Run the sql command by copying and pasting this:
SQLCMD.EXE -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query -i c:\SQL.sql >c:\output.txt
You can check the output file in the C drive, check the bottom of the file for:
Statistics for all tables have been updated.
Done updating statistics.2015-08-05 09:38:29.950
Then restart the “Update Services” on the server (click start and type services.msc)
Open WSUS and hit opens and run a server clean up. Then make sure you have chosen to install Windows 10 updates in the products and classifications section of options.