Finding the row # of a failed insert
Someone at worked asked me yesterday how to capture the row number of a failed insert. At first, I suggested he should wrap a try … catch around his insert statement and if that doesn’t help, try sql profiler and looking at the errors event. Either of this worked because his insert statement [...]