Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling SP on another server

Status
Not open for further replies.

dandot

Programmer
Jul 19, 2005
53
CA
I am writing a SP on one server..

however I need to get information from a db on another server via a SP or query ... is there a command that lets you do this?
 
You can try creating a DTS package if you are using SQL Server 2000 or SSIS in SQL Server 2005. Or you could create a linked server. The DTS and SSIS has better performance I believe.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top