Remote Stored Procedures

• marsjupiter

  SSC Rookie

  Points: 28

  More actions

  June 10, 2003 at 7:42 pm

  #160248

  We use SQL server for a non-traditional

  application, to run some parts of a real time gaming network ( Slot Machines ).

  My question is can a local client ( Slot Machine ) call a stored proceadure on

  a local server, and that stored proceadure

  in turn calls another stored proceadure

  on a remote SQL Server.

  Thanks Dave

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  June 10, 2003 at 9:56 pm

  #460681

  Create linked server in local server to the remote server and call the SP using four part naming convention.