I have implemented a stored procedure in SQL Server 2005. I need to capture the possible errors. I have written an Insert To ... Select statement, so I read a row block from a Table1 to insert it into a Table2. But I could have an error, f.e. a conversion
error. I want to capture the row of the block that has generated the error for the insert. Is it possible? How?
Any helps for me, please? Many thanks
View Complete Post