Sybase RPC between different servers

local server: A
remote server: B

1. login to A
2. add server B records at A's interfaces file
3. isql to A's Sybase
4. sp_addserver [server name],[remote server network name (e.g. same as interfaces file)]

• sp_addserver B,B
• go

5. create proxy table [table_name] at "[server.db.dbo.table]"

• use master
• go


• create proxy_table proxy_tb_a at "B.db_a.dbo.tb_a"
• go


• insert into proxy_tb_a values(....)
• go