Option Name:  allow updates Usage:  sp_configure ‘allow updates’, 1 Default: 0 Maximum: 1 Requires Restart:  No What it does:  Once upon a time if you wanted to update system tables in your database you could do so, and this was the magic switch you needed to throw to do it.  In the current enlightened times people … Continue reading Optober – SQL sp_configure options – Allow Updates