Recursive triggers are set at the database level. It’s part of the database metadata information and is available through “sys.databases” view.
You can use the below query to check whether the recursive triggers are enabled or not on your database:
SELECT name AS 'Database', is_recursive_triggers_on AS 'Recursive Trigger Enabled' FROM sys.databases
Here is the output:
