Call stored procedure on other server

[UGrad]

Hi,
I have two SQL 2000 servers, A and B.
On server A, there is a stored procedure C.
On server B, there is a stored procedure D.
Is it possible to call D inside C??

 

[checkai]

Sure, you need a linked server setup I think...

Here's what I've done

On server sql1 (linked server name sql2)

exec sql2.dbo.StoredProcName


"...your mom goes to college..."

 

[vbkris]

hmm, wht code do u write to link the servers? i thought that u needed to open some kind of connection to the 2nd server???

Known is handfull, Unknown is worldfull

 

[jbenson001]

You can create a linked server with sp_addlinkedserver, or do it though EM.