SQL Server

[Sreedhar]

Hello,

I am seeing strange behavior of ODBC stage while accessing the SQL Server.

When I use the following SQL

Select
A,
B,
C
from <Table>

It is hanging after fetching some 100 -1000 records (Running on a four node config)


When I run the same job with the following SQL it run fine


Select
A,
B,
C
from <Table> limit 10000

Any Ideas...

[chulett]

No. See if your DBA can help, trace the session and see what the 'hang' might be... or at least help determine if it is database related or not.