How to run procedure from remote server without linked server

Question

Post reply

How to run procedure from remote server without linked server

89netanel

SSCrazy

Points: 2130
More actions
November 27, 2018 at 4:06 am

#369197

Hello,
I need to run a t-sql batch that will run a stored procedure procedure at a remote server.
But i don't want to create a linked server for this task.
Can you please advise?
Thanks in advance!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99130 More actions · Answer 1

Have you considering using OPENROWSET or OPENDATASOURCE?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 2

What are you going to do with the output from the procedure - and what does that procedure actually do? If you need this data in the local instance - but don't want to use a linked server - then SSIS or BCP or Powershell/SQLCMD would be options, as well as openrowset or opendatasource.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

89netanel SSCrazy Points: 2130 More actions · Answer 3

Hi,

I dont need the output.

The remote procedure just update a table in the remote instance.

How can i just execute the remote procedure without linked server?

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 4

89netanel - Tuesday, November 27, 2018 9:28 AM
Hi,I dont need the output.The remote procedure just update a table in the remote instance.How can i just execute the remote procedure without linked server?

Any scripting language that can run SQLCMD. Powershell scripts can be scheduled through SQL Agent.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

How do you kick this off? Is a user doing this or does it need to trigger on some change in your existing database?

89netanel SSCrazy Points: 2130 More actions · Answer 6

Hi,
It's a part of job (in server "a") and i want that the last step will start another job at server "b".

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 7

I'd add a PoSh step and use that to call a SQL Agent job on another server. That way I could actually see the execution metrics on both sides, with some semi-loose coupling.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 8

This, Dba-StartSQLJob, will help
https://docs.dbatools.io/#Start-DbaAgentJob