Much thanks to Florin Lazar for posting how to fix MSDTC after install SP2 (http://weblogs.asp.net/florinlazar/archive/2004/06/18/159127.aspx). So far this is the only issue I’ve run into after installing SP2 (knock on wood).