Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 update a second sql serer from stored procedure

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2009-03-05 : 02:11:10
I have 2 servers
is it possible that within stored procedure on server 1 - I can send an update statement to execute a stored procedure on a db on server #2?

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-03-05 : 05:59:31
Add the second server as a linked server on the first server.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-05 : 12:30:42
update staement to execute stored procedure? what does that mean?
Go to Top of Page
   

- Advertisement -