we are using 2005. so synonym on an updateble table would work. correct?

switching where synonyms point sounds like a great idea. i need to read up on this.

thinking about it some more raised another question:

i will have some kind of process scheduled...

Mark,

you're absolutely right. those are just dump tables. no querying done on these tables. it's really only 4 columns, 3 out of which need to be dumped into master db.

here...

thanks Jeff,

here is the thing: i can't use "view". at least i don't think i can. this table is a WRITE table. user never views the data in it.

any...

Mark,

just to make sure i understand everything:

1. "rebuild a new TableA" - this is just a CREATE TABLE call? or is there anything more efficient that can be used to...

Mark,

how does renaming of the TableA affects inserts? as i have mentioned before, this table is being inserted into constantly. i am afraid that renaming this table while someone...

that sounds like an idea. here are the questions though:

is the table locked during the export?

what if at that particular moment i have hundreds of new inserts?

what would be...

those 8 servers are very intense, gets handreds of thousands of hits (INSERTS) in an hour.

what about the performance of the main server and the the other 8 linked...