Hi John,

>The commandtext will be very small. Remember, you have a parameters collection that will hold your individual parameters...

Maybe I'm missing something. Are you saying that an update SP should be created with all 70 parameters? I understand about the Parameters collection, but I thought SQL Server had a relatively limited maximum parameters (I can't seem to find anything about it mentioned in SQL Server Books Online).