Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block?

muhalet

Can I use something like try/finally construction for guaranteed run script with -b option in sqlcmd? The task is: turn on single user mode run some scripts that may be errors guaranteed turn off single user mode

Lost User

Yes, even Sql has the famous try..catch[^] block. Your "finally" would be included at the end of the "try" part.

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

J4amieC

Eddy Vluggen wrote:

Your "finally" would be included at the end of the "try" part.

Whaaaa....? No. Shirley that wont work like a finally block.

Lost User

Not guaranteed to execute indeed. Would it help to nest to try's, and check whether an error occured?

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

J4amieC

Eddy Vluggen wrote:

Not guaranteed to execute indeed

Well thats kinda the point of a finally block.