(DIR) Return Create A Forum - Home --------------------------------------------------------- ExcelSoft Database Professionals (HTM) 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) *****************************************************