in reply to Re^2: UPDATE not working with MS SQL Serverin thread UPDATE not working with MS SQL Server
Or set RaiseError, which would make it die automatically in case of error...