ISQL - Multi-Commands possible?

[Private_Member_19084]

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

[former_member188958 · Accepted solution]

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

[Private_Member_19084 · Accepted solution]

Hello Bret,

thank you very much.