Sorry for the late response...I missed your question.

I have not tried to debug directly from inside VS but it can be done. I saw a Microsoft video showing it (one the hour long show from thier website).

I did find this on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/_core_sql_debugging_limitations.asp

John