Are Stored Procedure failures logged by SQL Server? How can I see a list of stored procedure errors over a given timespan in SQL Server Management Studio 2008?
You can't, unless the procedure has code to write to the error log, or it results in a certain severity.

Investigate using TRY...CATCH error handling.   You should be able to capture errors and then write those to the error log.