SQL Server 2008 limit to using one processor on multiprocessor server

[maximumkai]

I have Microsoft SQL Server 2008 running on a server which has 2 physical processors installed on it. I would like to know if there is a way to configure SQL Server 2008 to only use one of the physical processors? If so, how?

Thanks

 

[JayKusch]

Check out setting the affinity mask

http://msdn.microsoft.com/en-us/library/ms187104.aspx

Thanks

J. Kusch