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 […]
Read More →Category: SQL Settings
Optober – SQL sp_configure Options: Show Advanced Options
It’s Optober – a time to look at all the SQL Server sp_configure options and figure out what they do and why they are there. In this post we look at ‘show advanced options’, just incase anyone can’t figure out what it does from the name.
Read More →