Just one last item on this guys. The MD-90 arrived and works great. Although it doesnt have a midi port but a USB port, it gets detected by Sonar as an E Drum. This shows up in Sonars preferences alongside other devices.
Because of this, you can go into the Inspector of Session drummer and the E Drum is there listed as an input option.
So now you can pick any drum kit you like in SD and the MD-90 acts as a trigger. Although Im only learning drums, this is a much better option than using a keyboard for drumming.
I'd imagine if anyone decides to buy one of the Yamaha or Alesis versions of these electronic kits they will operate the same way. Thanks again guys for the tips.