How to check if RECURSIVE TRIGGERS are enabled using t-sql

Question: An application owner has asked me if recursive triggers should be enabled on a particular application. Without looking at the GUI - how can I establish whether a database is configured as True  for recursive triggers?

Answer: Recursive Triggers are set at the database level. It's part of the database metadata information and is available through the sys.databases view.

This sql code executed will return all the recursive triggers information for all databases on a SQL Server Instance.

SELECT  name AS 'Database_Name' ,     
        is_recursive_triggers_on AS 'Recursive Triggers Enabled' 
        
FROM    sys.databases ;
GO