iam trying to run this following query for within EM
select count(*) from tablename
it gives me the following error.
microsoft[odbc sql server driver] timeout expired
i have set the time out options to 0 in EM server
properties, but still no luck. The same query runs fine in
sql query anlayzer. but fails with the same error if tried
within ado application. this table contains 50,00,000 rows.
please if any one has a soln kindly help