Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
Compatability view should be upgraded to catalog view.
Microsoft SQL Server 2000:
SELECT name FROM sysindexes WHERE name = '<index_name>'
Microsoft SQL Server 2008:
SELECT name FROM sys.indexes WHERE name = '<index_name>'