Instance Comparison

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mazzz SSCertifiable Points: 6139 More actions · Answer 1

Powershell would be one way to do it:

------------------------------------------------------------------------
Bite-sized fiction (with added teeth) [/url]

mazzz SSCertifiable Points: 6139 More actions · Answer 2

Also

select * from sys.configurations

might have what you need

------------------------------------------------------------------------
Bite-sized fiction (with added teeth) [/url]

goher2000 SSCertifiable Points: 5479 More actions · Answer 3

SSCertifiable

Points: 5479

June 1, 2011 at 10:04 am

Thanks much, now I have a starting point.

databoffin SSC Veteran Points: 279 More actions · Answer 4

For others performing a similar task, you could use Aireforge Compare (it's free) to compare sys.configurations and many other server objects.

Solving data & infrastructure issues via xTEN[/url] and our application, Aireforge[/url].

Cookies on SQLServerCentral