I am currently reviewing all sql server properties and configuration options for sql server 2008 R2 before doing the same for 2012. I will be documenting best practices for all settings as currently there is not a single document that handles this. I have noticed the following SQL Server properties that are useful to document are not in the sp_configure configuration options: a) Server authentication. b) Login auditing. c) Server proxy account. d) Full Text Upgrade Option. 1) Does anyone know if they are listed in sp_configure, and if not is there an easy script to obtain this information rather than just looking at the server properties? 2) Also, are there any other properties or configuration options that are not listed in sp_configure, but would also be useful to document? Let me know if you want a final link to this document and I will post this.