1
Reply

Execute stored procedure remotely

Kiran Jagathlal

Kiran Jagathlal

Dec 17 2013 7:24 AM
1.1k
Hi Everyone,

I am new to sql and just wonder if there is someone out there who could help me out.

I have two sql servers: server A and Server B.

Server B has the databases residing on them, and Server A has the sql agent. I have sql jobs that are on Server A, what I would like to know if I could remotely execute these store procedures( the jobs execute the store procs) on Server A. The jobs are on Server A and the store procs are on Server B.

I have already linked Server B to Server A. Is this possible?

Thanks,

Cheers
Kiran

Answers (1)