Remotely Executing a Stored Proc

I have an ASP page that executes a stored procedure on the local SQL Server instance, but I need that stored proc to execute another stored proc on a remote server. Basically, proc A on server 1 executes and passes a parameter to proc B on server 2. Is there a way to do this without linking server 2?
TIAPlease take a look at the linked server functionality. This allows you to execute a distributed query or call a remote stored procedure.

Remote SQL Job

I have a job created on my local server and I would like to add a final step
that executes a job on a remote server. The remote server already has the
job set up on it, I just need a way to trigger it. Any ideas?
Thanks,
nivekEXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
"nivek" wrote:
> I have a job created on my local server and I would like to add a final step
> that executes a job on a remote server. The remote server already has the
> job set up on it, I just need a way to trigger it. Any ideas?
> Thanks,
> nivek
>
>|||Thank you, that did the trick
nivek
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:1D6219E6-4061-4A1B-8268-477B76E56E3D@.microsoft.com...
> EXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
>
> "nivek" wrote:
>> I have a job created on my local server and I would like to add a final
>> step
>> that executes a job on a remote server. The remote server already has the
>> job set up on it, I just need a way to trigger it. Any ideas?
>> Thanks,
>> nivek
>>

Remote SQL Job

I have a job created on my local server and I would like to add a final step
that executes a job on a remote server. The remote server already has the
job set up on it, I just need a way to trigger it. Any ideas?
Thanks,
nivekEXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
"nivek" wrote:

> I have a job created on my local server and I would like to add a final st
ep
> that executes a job on a remote server. The remote server already has the
> job set up on it, I just need a way to trigger it. Any ideas?
> Thanks,
> nivek
>
>|||Thank you, that did the trick
nivek
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:1D6219E6-4061-4A1B-8268-477B76E56E3D@.microsoft.com...[vbcol=seagreen]
> EXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
>
> "nivek" wrote:
>

Remote SQL Job

I have a job created on my local server and I would like to add a final step
that executes a job on a remote server. The remote server already has the
job set up on it, I just need a way to trigger it. Any ideas?
Thanks,
nivek
EXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
"nivek" wrote:

> I have a job created on my local server and I would like to add a final step
> that executes a job on a remote server. The remote server already has the
> job set up on it, I just need a way to trigger it. Any ideas?
> Thanks,
> nivek
>
>
|||Thank you, that did the trick
nivek
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:1D6219E6-4061-4A1B-8268-477B76E56E3D@.microsoft.com...[vbcol=seagreen]
> EXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
>
> "nivek" wrote:
sql