I would create a view on the server that your customer logs into.

Example.

select * from [local table name]

union all

select * from [remote server].[remote db name].[schema].

This will allow...

It sounds to me like you are trying to clone a server. I think the quickest, easiest way to migrate the whole server is to do the following: ...

I forgot to mention my thoughts on triggers and cursors.

In my experience, these are the easiest ways to slow down your database. I even saw a few...

I've used SQL Server, Sybase and Oracle.

As far as OS reliability/security goes, Lately it seems that my Linux system has more security patches than my Windows 2000 Server. Also...

I've been using Kingston and Cruicial Memory for years without issues. I don't know if being a certified self-maintainer makes the difference but if something breaks, I just order...