DLL is a better choice for us than SPs because we don't want the headache of maintaining SPs on more than a hundred clients nationwide. With DLL and Exes, we just upload it in the WEB and clients will just download it.
Does each of your hundred-plus clients have their own database server?