Is there any reason not to just use sp_rename to do this? Keep both copies of the table similar to what Jeff is suggestng but instead of a view and trying to figure out what table is current.
1. Always populate Client_staging
2. Rename Client to Client_Temp
3. Rename Client_staging to Client
4. Rename Client_temp to Client_staging
That seems simpler unless there's some nasty over head with renaming?
I would think that it would be much simpler to use a synonym. I believe it only requires updating the synonym to the correct table.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA