Calling SP on another server

[dandot]

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?

 

[rodeomount]

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.

 

[SQLDenis]

create a linked server or use OPENROWSET

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[ca8msm]

Set it up as a Linked Server and use the naming 4 part convention - [server].[database].[schema].[object]


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]