The errors returned from the SQL Adapter are not very good.
I think they are returned as SOAP Fault. You might want to try casting them (see my BizTalk 2004 Sample here http://www.biztalkgurus.com/Samples/Delivery-Notification-NAck-Orchestration.html).
Not really sure if this gives you a better error or not for SQL though.