• I've been wondering how to find settings for years.  Learned a lot on this question along with the last article before it: @@OPTIONS, bitwise comparison, Databasepropertiesex, dbname(), Sessionproperties and even Databaseproperty [do not use].  Some may be horrified but you can go a long way without knowing these things.  Knowing them will let me go further.  Thanks for the question and research it lead to.