I see lots of sites that show how to set it, but I just want to see what it is first. What is the command to do this?
+2
A:
In Script:
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'max degree of parallelism'
GO
Or using the UI : Under Advanced Server Properties
Preet Sangha
2010-05-13 21:23:08