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>'