tags:

views:

67

answers:

1

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

alt text

Preet Sangha