[T-SQL] How to see sql server configurations

SELECT *
FROM sys.configurations

[T-SQL] Advanced Server Configuration

“How I check all the advanced configuration of the SQL Server?”

EXEC sp_configure 'Show Advanced Options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure;