• We probably could use BCP and realize some performance improvements, definately. However, we're finding the performance is more than adequate, we've got it in Production as well as having tested it to a fair thee well, and the amount of code on both sides of the equation, the app server & the database, is a lot less than implementing a bcp solution would be. It really is working. Don't get me wrong. I don't see it as a magic bullet. It merely fills our needs well and could fill others needs under similar circumstances. As usual with databases, it depends.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning