Nice easy one today.
alex.d.garland (11/7/2012)
I could be wrong but I don't think this is new to 2012 - I think the OP was just specifying a single known version for accuracy. Pretty sure it works on 2008 although as a developer I don't tend to do a lot of config professionally...
Yes, it can be done with sp_configure on 2008 (and 2008 R2). But those two versions also offered two other methods of doing it (the database mail configuration wizard, and the policy based management surface area configuration tool (both inherited from 2005). Maybe in 2012 it isn't possible any more to do it three different ways, just the one way. Certainly a quick search in BoL doesn't throw up any method other than sp_configure to do in in 2012. If so it makes sense to specify 2012 to avoid any argument about whether it should be a "tick multiple boxes" question instead of a check one button question.
Tom