call DBREMOTE inside procedure

[reimer_pods]

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

[reimer_pods]

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

[chris_keating]

You can use xp_cmdshell system procedure.

[VolkerBarth]

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...

[Breck_Carter]

> 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;