June 25, 2015 at 6:15 am
How can we verify that two of the server configurations are same or not?
what setting needs to be consider?
I have Server A and Server B.
Is there any script to compare the differences b/n those two servers
June 25, 2015 at 6:37 am
This is very broad sense. What exactly you would like to compare?
To start with comparing the output of two server in xls. You can execute sp_configure to get the detail configuration. Check if advance option is on to get all the configuration. Also you can check the system and user database settings by executing query on sys.databases. You can also check the users and permission, jobs, other sql server features in use etc.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2015 at 9:57 am
similar to what was already suggested, you can start by comparing the results of
SELECT * from sys.configurations order by NAME
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply