My user has been granted ddl_admin and db_owner within the database.  The table owner is dbo.  Still getting the same error msg.

Thanks!

Creating a secondary db might be an option if security doesn't provide the means.

Are there any other options?

Our users get flat files from clients and set up temp tables to perform data manipulation on some large data sets thru QA.  It doesn't happen a lot, but isn't...

It is my understanding that global temp tables go away once all connections using that table are disconnected.  So, if I create one and then 1 other user accesses that...

First, thanks to everyone for offering suggestions!

We are trying to implement a policy that we think will minimize the necessity for data recovery.  Recovery is expensive because the entire process...

Unfortunately, restoring from backup and fixing data is time and resource intensive (expensive).  While we do have a backup/restore strategy, we'd also like to do what we can to limit...