View Single Post
 
Old September 15th, 2005, 06:03 AM
ami4quest6 ami4quest6 is offline
Registered User
 
Join Date: Sep 2005
Location: Craiova, , Romania.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default calling a store procedure from another server

Hy

Has any of you an idea of how to call a stored procedure (or many) from another SQL server instance (from a different computer)? - I have the username and password of the other sql server and the IP of the computer that instance is running on.

Ex. computer 1 - sql server 1 - proc1
 computer 2 - sqlserver2 - proc2

proc2 - calls proc1...for example


HElP


Thank you very much

Amalia






Floriana P