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 |
|
bhavyan_jobs
Starting Member
6 Posts |
 Posted - 2002-11-22 : 03:58:31
|
| Hi There,I want to pass some variable as an output vairable to the stored procedure that has to be executed on remote server. and thus want to collect the returned value into that variable.that i want to run the followingexec XYZServer.XYZDatabase.dbo.spRemoteProcedure@SomeVarCan u ppl plz suggest how to do it ????ThanxbhavyaBhavyanidhi KukrejaNetwork Programs India Ltd.Member Technical StaffB-1-C, Sector 10Noida-201301U.P.Phone-0120-4536622 |
|
|
burbakei
Yak Posting Veteran
80 Posts |
Posted - 2002-11-22 : 04:06:26
|
| exec XYZServer.XYZDatabase.dbo.spRemoteProcedure @SomeVar OUT |
 |
|
|
bhavyan_jobs
Starting Member
6 Posts |
Posted - 2002-11-22 : 08:03:03
|
Thanx Buddy !i'm so sorry, i's so stuck with the work ki i forgot the fact u have reminded me .......bhavyaquote:
exec XYZServer.XYZDatabase.dbo.spRemoteProcedure @SomeVar OUT
Bhavyanidhi KukrejaNetwork Programs India Ltd.Member Technical StaffB-1-C, Sector 10Noida-201301U.P.Phone-0120-4536622 |
|
|
|
|
|
|
Output Variable in a Remote Procedure