sp_configure

I normally don’t like abbreviations when writing code but in this case i’ll make an exception: When setting the different configuration parameters with sp_configure it might be good to know that SQL Server recognizes any unique string that is part of the configuration name. For example, if you want to see advanced options of sp_configure you can write: sp_configure ‘show’, 1 instead of writing the whole sp_configure ‘show advanced options’, 1 Same goes for every configuration option you want to set, just make sure the string you write is unique among the configuration options. Of course, after this,  you have to run reconfigure to set the configuration as usual.
/Jan Nieminen