Are views updateable in SQL Server 2000? I've never tried to use views beyond a select capability.

Another option I could employ is to encrypt the data so that it is...

No worries. The ideas have given me some options to consider. However, it appears that I will resign myself to granting select, insert and update permissions on the custom tables....

Unfortunately, Dynamic SQL is a key component since I don't want to manage exponential sprocs with the addition of every client. Each client's table is configured to their specs, but...

Are there any concerns with using Application Roles with the .NET managed Sql provider? I noticed several concerns with the loss of connection pooling and therefore performance, but those concerns...

These are real-time requirements. Any inserts or updates are immediately requeried by the web application. Otherwise, your suggestion is good. Queuing the updates would require that only select permissions be...

By "ambiguous" I mean that I don't want to have explicit column names in the stored proc. Because the tables can vary by client, I don't want to code the...