There was a performance fix made in SQL Server 2000 SP2 for some enumeration
problems if you are already running that version then there is not much else
that can be done.
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
> Hi All
> I am using DTS to extract data from a Oracle database which as about
> 17,000 tables and about 12,000 indexes. I am using the MS OLE-DB
> provider for Oracle when I double click on the transform it takes more
> than 10-15 minutes for the screen asking me for the query. If I access
> a Oracle database that as 50 or so tables the MS OLEDB provider comes
> out fast. Does this need a MDAC patch ?