/*
 * instance parameters
 */

-- version and edition
select @@version
SELECT SERVERPROPERTY('Edition')


-- show instance parameters from stored procedure "sp"
-- based on catalog view
exec sp_configure;
exec sp_configure 'awe enabled'; -- one property value

-- show instance parameters from catalog view
select * from sys.configurations where name like '%audit%';