[AccessD] SQL - Copy * to another table

Is there a way to get the SQL error statement back from a stored procedure into Access?  Or even 
better is there a way to log the error statement inside of SQL Server?  I could read that table from 
Access if I can log the errors.  ATM I am just catching them in a catch statement and PRINGing them 
to a window in the query window.

-- 
John W. Colby
www.ColbyConsulting.com