Re: Memory Problem with 1 DB. Other DB ok

[Gabriel Dunn]

I used the OPENQUERY function. Which Forces "order by" to be performed at MySQL

OLD Method - Theoretically works, except when it doesn't
-----------
select id
into #temp_MySQL_ID
from MYSQL_WEB_PROD...wp_users


NEW Method. Forces "order by" to be performed at MySQL
-------------------------------------------------------
SELECT *
into #temp_MySQL_ID
FROM OPENQUERY(MYSQL_WEB_PROD, 'SELECT id FROM wp_users order by id')