At the session level

To enable merge joins for a session, use:

set sort_merge on

To disable merge joins during a session, use:

set sort_merge off

The session setting has precedence over the server-wide setting; you can use merge joins in a session or stored procedure even if they are disabled at the server-wide level.