I know this is an ancient post, however I came across it when searching for a way to get process information into SQL Server. This method is fundamentally flawed as...
Right, it shouldn't happen in a production database but will have to be dealt with during ETL processes, especially if you want to be able to report on such errors.