We are always upgrading from lower version to highest version. There may be chances that indexes are mismatched from our old version(2000) to new version(2008). I have tried to create script which will use of OPENROWSET command to read system tables from SOURCE database and compare it with TARGET database. This script will return difference from SOURCE to TARGET tables which are exists in TARGET database. We are doing that because it’s possible that we don’t want some table from older version. This script also provides create script for TARGET database to sync indexes with SOURCE database.
Below is script to download.