if it is sql 7.0 -- there are many documented bugs with regard to dual processors...so many in fact, that when running 7.0 its advisable to limit it to running...
I find that vb is absolutely the best external manipulation language for sql server. i have created several small applications for manipulating dts on sql and find the api...