I have a problem with my application that works on my dev SQL Server 2008 (Developer Edition), but not on a production SQL Server 2008. Is there an easy way to export the settings from the production server and compare it to my server configuration?
What I found out is that I can export Facets in SQL Server Management Studio to XML files and compare them in a diff tool.
Is there any other/better way to export and compare settings of two SQL Server instances?
"I have a problem with my application"
-- care to elaborate? There are many places to look for a problem...