if you're on splat, use addictive drums 2. takes a while to master, but there's a wealth of tutorials. all you do is select a kit, select a beat, drag-n-drop the beat to a midi track routed to ad2. earlier versions of sonar have session drummer...
or, use fruity loops to create patterns, save as wav, import into sonar.