Hi Ken,
1. I assume tha you're talking about an SQL Server database
2. I bet you upgraded this database from 6.5.
If these two assumptions are true, then you need to set the database compatability level to 70.
Use the system stored procedure
sp_dbcmptlevel [ [ @dbname = ] name ] [ , [ @new_cmptlevel = ] version ]
Cheers,
Andrew
>For some reason a database of mine will not allow "Select Top". Does anyone know why this is?
>Even in the Enterprize manager (SQL 7) when you right click on any table in the database and try
>to choose "Open Table"/ "Return Top..." is greyed out. Any help?
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.