I am using SQL Server 2008 Management Studio to connect to SQL Server 2000.
use [MyPrettyDb]
select top 19 * from information_schema.tables
It works nice and sweet and quick. But this:
select top 20 * from information_schema.tables
Stops by timeout.
What is the reason for the timeout?
P.S. select count(*) from information_schema.tables returns quickly; there are 334 tables in the database.
I have resolved this issue by my own. The issue is only in Windows 2008. And 32/64 confilcts.
There are two odbc drivers in Windows 2008: 32: in System32 folder (or system) 64: in sys SystemWOW64
As I understood by default it using 64 version. But its not compatible with 32 version on remote machine. That why I had strange behavior.
Run odbc wizzard friom 32 folder and it magically become work properly.