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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 db library, return params from nested call to a remote sp

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-29 : 10:32:53
Peter writes "using app with db library on sql 2k

1. make call to first server (sql2k) sp
in first sp make remote call to second sp to remote server (sql6.5)
2.return parameters from second sp comes in front of return parameters of first sp when returning from db lib call
3.expected behavior: return parameters from second sp to NOT be visible to db lib app, only first sp return params to be visible
4.when first server is 6.5 this does NOT happen"
   

- Advertisement -