• Hi,

    That's what I'm doing for some cases, just like I say "rather than writing code after every update statement checking @@ROWCOUNT?".

    But since I'm using SQL Data Compare some scripts can have more than 1.000 update statements and it's not practicable to do that check after every update.

    Pedro



    If you need to work better, try working less...