Tag Archives: mssql

WSUS and “Cannot save configuration because the server is still processing a previous configuration change”?

For future reference…

If WSUS starts responding with the message: “Cannot save configuration because the server is still processing a previous configuration change”, run this SQL command:

UPDATE tbSingletonData SET ResetStateMachineNeeded = 0

And in the long term, consider this:

https://community.spiceworks.com/scripts/show_download/2998-wsus-automated-maintenance-formerly-adamj-clean-wsus

Trim()

A small curiosity…

The TRIM() function in Excel works completely differently than TRIM in SQL. In Excel, it removes all occurrences of spaces except for a single occurrence between words, while in SQL it removes only spaces from the beginning and end of a string.

More vCenter Server problems – database in suspect mode

After a few surprises that appeared less than a month ago in the article https://www.karolszczepanowski.pl/2015/02/24/problemy-z-vmware-vcenter-server-5-5/, it was time for another one…

This time the vCenter database stopped with the not very informative note “(Suspect)”, probably because something broke after a power failure (again).

Fortunately someone has already described the problem, so here is the source link:

http://www.vmdude.fr/en/tips-tricks-en/suspect-vcenter-database-on-sql-express/