Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 0 Rows from Enterprise M. and 2891 from Query A.?

Author  Topic 

solorzam
Starting Member

3 Posts

Posted - 2001-11-20 : 13:46:12
I have a database in SQL Server 7.0 on a Windows 2000 Advanced Server, which I am accessing from the SQL Server Enterprise Manager for SQL Server 2000 Client. When I select ALL rows from this table, I get zero, but if I run the SELECT query from the Query Analyzer client to obtain all the rows, it works fine ! Is there a conflict from accessing a SQL Server 7.0 DB from a SQL Server 2000 client ?

Thank you.
Mauricio Solorzano


Best Regards,
Mauricio J. Solórzano
Software Engineer
Business Applications
Aegis Communications Group, Inc.
   

- Advertisement -