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 |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2004-03-18 : 04:15:40
|
| Hi,I need to get the result from a store procedure located on another server (#2). I can not use linked server because of some confidentiality concerns. Is it possible to use OPENROWSET to access this store procedure get the expected recordset back that way?The store procedure returns a recorset on #2.Thanks, Paul |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-03-18 : 05:41:26
|
| If you can't link it, you can't get it.If you know about OPENROWSET, why don't you look it up in BOL? |
 |
|
|
|
|
|
Call Store Procedure other server OPENROWSET ?