Alvin Ramard (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

Gail just responded to...

Chad Crawford (2/16/2010)

---

Sorry Barry. 🙁

BTW - Jason, did you know that our resumes cross? We were at UBS at the same time, but I think in different offices...

Gail just responded to the suspect thread....

I would give that a shot.

Also, out of curiosity. I know the disk subsystem is better on the server. Is it a san or locally attached disks? ...

Chad Crawford (2/16/2010)

---

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the...

I second Lynn's motion.

Please provide more information. Error messages are critical pieces of information to share.

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the thread above, and...

I was recently convinced to go ahead and re-certify. I was looking to use the same materials as Tommy for this particular exam.

Anything else running on the server besides SQL?

Are the statistics up to date on the server?

Are the indexes in a reasonable state of defragmentation?

Lynn Pettis (2/16/2010)

---

As many times as we have run into questions asked in the wrong forum, I did ask the OP which he is working with, SQL Server 7/2000 or...

Elliott W (2/16/2010)

---

I completely understand, because of the title I never looked at the group it was in.. But I stand by my recommend and the link posted.. ...

Elliott W (2/16/2010)

---

That link you sent...

I currently run 75% of my databases on SQL 2000 (I know, big ouch). I use one instance of SSIS 2008 to perform various tasks against all of my...

Only requirement is that SSIS be installed. If it is installed, it will be able to perform this for SQL 2000.

Please enable logging from within the maintenance plan. It will give more detail about the cause of the failure than the SQL Agent log.

Here is a link that shows...