I am not talking about scripts. (?) I was referring to the default parameters for the SQL services:

services>properties>recovery tab>First failure, Second failure, Subsequent failures and why they are all set to "Take No Action".

Maybe I should have started a new thread.