passing values from one SQL server to another

Quote:

Originally Posted by holly

Hi

Is it possible to pass the value of a stored procdure on one sql server to a stored procedure on another SQL server??

Thanks in advance!!!

If it is HOW???

:confused:

I'm not sure what you mean when you say you want to pass a value from one stored procedure to another, but I assume that you want to take the returned value from one stored procedure and pass it as a parameter to a second sproc.
In that case you need to add the second server as a linked server to the first server. You can do this with EM or a set of system stored procedures. Using EM is probably the easiest.
To execute a stored procedure on the remote server you simply specify the procedure using the four party name (server.database.owner.objectname) e.g. myserver2.mydatabase.dbo.mysproc @someparameter.