How to know the system configurations in SQL Server

Posted by Bandi under Sql Server category on | Points: 40 | Views : 664
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....

SELECT * FROM sys.configurations

Comments or Responses

Login to post response