DIR Return Create A Forum - Home
---------------------------------------------------------
ExcelSoft Database Professionals
HTML https://esdbp.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: Scripts
*****************************************************
#Post#: 59--------------------------------------------------
Compare Index Between Databases
By: babu_exceldbp Date: April 23, 2014, 6:31 am
---------------------------------------------------------
Script which could be used to compare indexes in two or more
databases. This script returns the list of indexes which are
not having uniform definition across databases. There are no
stored procedures associated with this script and could be
executed on any instance.
You can run this script from a server where linked server
configuration is available for all servers/dbs you want to
compare in a Federated environment.
Supported Version: SQL Server 2008 and above.
(Pl. rename txt file into .sql file to use the same)
*****************************************************