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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-11-23 : 03:26:15
|
| Hi, Is there a way to connect to another SQLServer and read its data through a stored procedure, or function, etc.?I'm looking for a way except linked server. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-23 : 03:43:04
|
| yup. if you not want to set up linked server the other option is OPENROWSET. look for details belowhttp://msdn.microsoft.com/en-us/library/aa276850(SQL.80).aspx |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-11-23 : 04:30:34
|
| Thank you visakh! |
|
|
|
|
|
|
calling another server connection through a stored