Syntax options:

    ON alias | AND ON alias

    Specifies the alias for a database for which you want to specify
    transaction options. An alias is a name for a particular attach
    to a database.

    Use the ON clause when you attach to more than one database and
    want to specify different transaction options for each database.
    (If you omit the ON clause, the single set of transaction
    options in the SET TRANSACTION statement applies to all attached
    databases.)

    You can include multiple sets of transaction options, one for
    each database, in multiple ON clauses separated with the AND
    keyword.