I'd advise you to install the latest MDAC and then try reinstalling SQL Server 2000.

Of course, there may be a few more issues regarding your system configuration.

Have you tried http://www.dll-files.com/ ?

have you tried running the Component Checker for MDAC?

http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

yes, I'm hitting the same remote linked server in both local servers. no load whatsoever.

however, you're right (and it makes sense, I oughta smack myself in the head for not...

there are also a few things I recommend

- creating X datafiles for tempdb, X being the number of processors available

- one single logfile for each database, on different drives (write...

I've tried to enforce the approach where the user default DB is **not** the master database and I've got a few troubles, namely when deleting the mentioned databases (even if...

the server is not logging, altough it's working.

I just want to figure out any way to put it back as it was (logging) without having to restart the server.

Once they're stored in MSDB, this has always sounded to me like an obvious way to do so.

I want to copy some DTS jobs from a development server to a...