SQL Server provides the
sys.configurations catalog view to know the value of each server-wide configuration options such as xp_cmdshell, SQL Mail XPs, Ad Hoc Distributed Queries, clr enabled, query wait (s), max degree of parallelism, cursor threshold, two digit year cutoff, show advanced options, fill factor (%), nested triggers, disallow results from triggers, locks, and user connections values....
Example,
SELECT * FROM sys.configurations