Question Re: call DBREMOTE inside procedure in Technology Q&A

call DBREMOTE inside procedure

Baron — Tue, 20 Mar 2018 04:19:53 GMT

Is it possible to call the DBREMOTE or an external batch file from within the Database (say inside a procedure for example)?

Re: call DBREMOTE inside procedure

reimer_pods — Tue, 20 Mar 2018 04:26:50 GMT

Could you be more explicit about what you're trying to achieve?

Re: call DBREMOTE inside procedure

chris_keating — Tue, 20 Mar 2018 06:17:20 GMT

You can use xp_cmdshell system procedure.

Re: call DBREMOTE inside procedure

VolkerBarth — Tue, 20 Mar 2018 06:47:17 GMT

If so, I would recommend to use an event to run DBREMOTE, because that would run within its own connection, whereas a procedure would be waiting until DBREMOTE has finished its run...

Re: call DBREMOTE inside procedure

Breck_Carter — Tue, 20 Mar 2018 08:25:23 GMT

> a procedure would be waiting

You can also fire-and-forget with the Windows START command...

BEGIN
DECLARE @return_code INTEGER;
@return_code = CALL dbo.xp_cmdshell ( 'START "title" /B "command or program"', 'no_output' );
SELECT @return_code;
END;