I spoke too soon. My previous suggestion to stop/start the MSSQLService mid-stream is bad advice. Apparently this only treats the symptom, but not the core problem because a...

I too received the "not able to authenticate" error when installing SP3a. The above suggestions did not help me (setting DSQUERY=DBNETLIB in registry, installing MDAC 2.7 SP1 Refresh, setting...

Any recommendations on how when or how often the "Reorganize data and index pages" option should be used?

Both Steve and Andy called it. Using Profiler I realized I had the "Reorganize data and index pages" option set on my database maintenance plan. Each night all...