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

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
--

Yes this is possible if you set up a linked server.
"Vikram" <vikram404@hotmail.com> wrote in message
news:7acafb49.0405210156.514c2e42@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