Handy SQL for Surface Area Config

This SQL is handy, especially in SQL Server 2008, to configure the correct BPMC surface area settings:

sp_configure 'show advanced options', 1
reconfigure
go
exec sp_configure 'xp_cmdshell', 1
reconfigure
go
sp_configure 'show advanced options', 1
reconfigure
go
sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure
go