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

Just a wild guess, cause I never really looked how SQL Server does this (VFP doesn't cause errors on these): could it be that there are more than 10 records tied for first and choosing the top 10 would cause an error? Or that less than 10 records qualify to be in the result?