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.
| Author |
Topic |
|
djseng
Starting Member
25 Posts |
 Posted - 2003-10-03 : 10:08:54
|
| Hello, Just checking to make sure, but I don't suppose it's possible to execute a stored proc on another server within another stored proc... especially if the stored proc on the other server needs a different logon? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-03 : 12:46:30
|
| You can do this using linked servers.Tara |
 |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2003-10-05 : 18:52:02
|
| SP_AddLinkedServer to be specific. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-10-05 : 19:28:52
|
| Or openrowset or openquery or osql or bcp....Oh and dts as a last resort.Depends what you want from the SP.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Execute a sp within another sp...