Stored Procedure Across SQL Servers

[Vikram]

Hi,

Is it possible to write a Stored Procedure which can update the data
from one SQL Server to another SQL Server ? I know its possible
through DTS, but want to know if its possible using a Stored Proc by
passing the two server names as parameters to the Stored Procedures.

Thanks,
Vikram

[David Portas]

You can do this easily in TSQL provided you create a linked server on the
server where you want to run the code. Then you can reference objects on
either server using fully-qualified names:

ServerName.DatabaseName.OwnerName.ObjectName

Read about Linked Servers in Books Online:
http://msdn.microsoft.com/library/en...erver_4uuq.asp

--
David Portas
SQL Server MVP
--

[MissLivvy]

Yes this is possible if you set up a linked server.
"Vikram" <vi*******@hotmail.com> wrote in message
news:7a**************************@posting.google.c om...

Hi,

Is it possible to write a Stored Procedure which can update the data
from one SQL Server to another SQL Server ? I know its possible
through DTS, but want to know if its possible using a Stored Proc by
passing the two server names as parameters to the Stored Procedures.

Thanks,
Vikram