As I detailed in 2012, I ported Kimberly Tripp’s duplicate index finder to Microsoft SQL Server 2000.
You will need to install two scripts into your SQL Server 2000 master database:
- sp_SQL2000_helpindex – A modification of the built-in
sp_helpindex, based on Kimberly’s script, to output the index information for a particular table.
- sp_SQL2000_finddupes – A script that goes through all the tables in a database and looks for duplicates, based on the output of
The scripts are current as of 19 June 2020, with no known issues at this time. Keep in mind too that SQL Server 2000 has been out of support for a number of years.