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

Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays