We have a problem where someone, or an application, or the nightly Integrity checks or (?) attempt to delete a master record pointed to by a detail record. This happens infreuqently. If we tried the same action from EM or QA, referential integrity would stop us abruptly with an error message. Does SQL maintain a "log" of these "error messages" that I can access? (The transaction log\ t-sql Profiler trace are way too detailed to be useful. I don't want a list of everthing -- just a higher level-trace of errors).
TIA,
Bill