You will need to install two scripts into your SQL Server 2000 master database:
- sp_SQLskills_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_SQLskills_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 29 September 2017, with no known issues at this time.