Does SQL keep Log of failed update query
I'm using SQL 2005
Does sql keep a log of failed updates
I have a problem where a sql statement would update a specific record in a table.
Problem is the table referenced was wrong so the update will fail.
I would like to retrieve the update statement passed to sql so I can reupdate to the correct table
I tried using DBCC LOG but no records of failed updates
Any ideas of where to look or if this is even possible?