Question Re: ISQL - Multi-Commands possible? in Technology Q&A

ISQL - Multi-Commands possible?

Private_Member_19084 — Mon, 12 Oct 2015 13:12:46 GMT

Hi experts,

is it possible, to enter more than just one command in ISQL?
I think it is possible, but how is the syntax?

So entering this doesn't work, as I always get the error that the syntax isn't ok.

1>sp_sysmon "begin_sample"

2>dump database <SID> to "<path>"

3>sp_sysmon "end_sample"

4>go

Re: ISQL - Multi-Commands possible?

former_member188958 — Mon, 12 Oct 2015 13:32:48 GMT

If you have more than one stored procedure in a batch, you must use the "exec[ute]" keyword in front of the stored procedure name. "execute" is optional if the stored procedure is the only thing in the batch.

-bret

Re: ISQL - Multi-Commands possible?

Private_Member_19084 — Mon, 12 Oct 2015 13:37:46 GMT

Hello Bret,

thank you very much.