Kiran Jagathlal

Kiran Jagathlal

  • NA
  • 1
  • 1.5k

Execute stored procedure remotely

Dec 17 2013 7:24 AM
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)