>Hi,
>
>I'm using SQL Server 7.0. I restored a database from a backup, and for this database, when I try to:
>
>- select top 10 * from sysindexes. The SQL returns an error '10' is not a valid entry.
>
>for the other databases, like master, Northwind, etc. the problem doesn't occur.
>
>Does somebody know why it happens?
Marcelo,
Is your SQL Server 7.0 in 6.5 compatibility level by any chance?
--sb--