>>Probably, I misunderstand you. If it's databases from different servers,
>>then I don't know whether it's possible at all. I would imagine that you
>>could create the same database on both servers and make backup/replication
>>link to provide that both databases will be identical. This is feasible, but
>>I'm not SQL Administrator and cannot advise on this issue.
>
>FWIW Sybase SQL Anywhere does not support joins across databases, even if they're running on the same server it doesn't matter, as far as the server cares they're completely separate database. Any joining would have to be done on the FoxPro side (via remote views) but performance would take a serious nosedive and it wouldn't be a good idea for any heavy duty joins.
>
>-- Dave
Yes, but in case of SQL-Server stored procedure it's not a problem to call different databases of the same server.
Edward Pikman
Independent Consultant