Excerpted from 9CBS ------------------------------------ ------------- Create a link server EXEC SP_ADDLINKEDSERVER 'SRV_LNK', '', 'SQLOLEDB', 'Remote Server Name or IP Address' Exec Sp_addlinkedsrvlogin' SRV_LNK ',' FALSE ', NULL,' User name ',' password 'exec sp_serverOption' srv_lnk ',' RPC out ',' True '- This allows the stored procedure to call the link server
Declare @ID INTEXEC SRV_LNK.QSoft2.dbo.ins' people, 'Mobile', '13598136858', @ id = @ ID OUTPUT
