One of our SQL 2000 servers has an issue after an unidentifed event and began running at a snails pace.
I know SQL 2000 is no longer supported.
We are running IIS on the same server and no connection can be made to the SQL server on the same machine.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specifed driver could not be loaded due to system error 5 (SQL Server).
A std query from outside the server works fine until a Join is added then it runs forever.
A backup and restord did nothing as well as reindexing, shrinking and optimizing.
After restoring the database on another SQL 2000 server we compared the speeds.
Bad server 4:22 minutes good server less then 1 second.
Any sugguestions?????? email@example.com