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
sp_SQL2000_helpindex.
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.