How to get Database engine ( SQL Server ) setting information

I checked this query against 2008 and above. You can view all sql server server information using following built in procedure.

Exec xp_msver

You can change setting by using advance setting option.

Index Name Internal_Value  Character_Value