We're running a 3rd party ASP application with SQL 2008 Web edition. I suspect the application is failing to record some transactions and isn't reporting SQL errors, e.g., timeouts. I've confirmed with the vendor that the application does not report or log errors in any way.
I'd like to not have to instrument the application code and am looking for another solution to identify any SQL errors that may be happening.
Is there any such tool available or is this built into SSMS?
PS: I am a casual user of SQL these days but when pointed in the right direction, I usually get there.