Execute stored procedure remotely
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