T-SQL equivalent oracle show all

Question

what is sqlserver T-SQL equivalent to show all oracles by listing a set of parmas in a database?

Answer 1

select @@options

see http://www.mssqltips.com/tip.asp?tip=1415 for decoding it.