Compare database instance settings

• daustinash

  SSC Eights!

  Points: 859

  More actions

  March 5, 2009 at 6:21 am

  #131497

  Good morning.

  I have two SQL Server 2005 machines and am looking for a way to export and compare all engine level settings. I have a piece of code that behaves differently between the two machines and suspect a server level configuration option to be the culprit.

  Thanks,

  dnash

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 5, 2009 at 6:50 am

  #953987

  Why don't you start with comparing sp_configure output first.

  MJ