Error log only showing DB and log backups

[SQLWilts]

Hi,
I have been working with SQL server for about 12 years now, but have never really kicked around trace flags - which I suspect this issue is associated with.
I have a number of very busy SQL servers but the only thing in the error log is the backup info (log and DB). I want to see all SQL errors (just found that an app was failing silently trying to add a duplicate key to a table, for example).
Do I have to turn on 3605, or another/combination of traces?
I know that there is a performance kicker, but the app developers are not, well, the BEST that ever graced our planet (being as polite as I can here...) and I need to monitor the error log.
Any help/advice appreciated

 

[mrdenny]

Setup a trace in SQL Profiler and monitor the app, and all errors. This way you have the statements and the errors.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[SQLWilts]

Hi Denny,
Yeah, I have done that already. thing is, I normally see a lot more in the SQL log than just successful backups. for example, if something failes, it would normally write something to that effect to the app log - it isnt - NOTHING is! (Other than successful backups) I'm just wondering what I am missing here...