I can't seem to find any information on how exactly to do this. Basically I want to move a particular table on my DB to a remote SQL server, and have write operations (destined for that table) to be written directly to the table on the remote server.
If you have set up one server as a linked server, you should be able to set up one of your tables just as a view, so that operations that happen to it actually happen on the underlying one (on the remote server).
That's the theory at least, and it ought to work, but you should be wary of network latency and things like that. You may find it just doesn't perform well enough, and that you need some sort of a process which polls the table on your database for changes that need to be written back. But then the tables won't be perfectly in sync (for obvious reasons).
Microsoft sta conducendo un sondaggio in linea per comprendere l'opinione degli utenti in merito al sito Web di Msdn. Se si sceglie di partecipare, quando si lascia il sito Web di Msdn verrà visualizzato il sondaggio in linea.