whoteegan,

I'm not sure what you mean by 'staging' tables. When the applications are re-written, they will be done in .Net. We do not have a problem with using...

Jonathan,

Application roles would work for a couple of the applications, but most hit more than one database. Thanks anyway.

Thanks to everyone for their response. I was afraid there wouldn't be a good solution. We don't want to grant access to our SQL Server data to our clients's...