Controls the ability to use the Transact-SQL outer join operators *= and =* in statements and views.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY PUBLIC OPTION||Yes||Yes, with SET ANY PUBLIC OPTION|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
Support for Transact-SQL outer joins is deprecated. Setting this option to On allows you to use Transact-SQL outer joins.