Displays information about the specified trigger. If you do not
    specify a wildcard or list of trigger names, SQL displays the
    names of all the triggers in all attached databases.