I recall that you used to be able to tell SQLServer exactly which processors it could and could not use on a multi-proc box. (NT, of course :) ). So in NT, it is at least possible. If that is your platform, you can probably check the SQLServer docs to see if they are driving that or simply utilizing some exposed OS method.

- Chris