You might want to include hardware in your suspicions. I remember reading on Novell's website about using Error Correction Memory in servers. I've had sporadic problems traceable to a motherboard, which went away when I replaced the MB. Maybe it's SQL, or maybe it's the hardware?



>
>Yes we have SP 2 installed. We have dozens of servers running SQL server 7.0. A few days ago SQL Mail Service failed on one manufacturing machine and otherwise continued to run. Within a day there were 3500 e-mail notifications sent to one person and since the service failed, he did not know. When the problem was detected and resolved the e-mail was available. What a joy to be so popular - 3500 e-mails in a day due to a lost service.
>
>A day later my local copy of SQL Server lost its brains and I could not start SQL Server or access any data. The person who takes care of SQL Server recommended another product for e-mail service.
>
>We work with a lot of data at this manufacturing plant (we make cars and trucks) for General Motors and Toyota. Every step of the manufacturing process is data driven. The plant is about 1,000,000 square feet on three stories and we have about 80 developers.
>
>Things will work for two or three months and then "interesting things will happen". For no known reason some application forgets how to work and shuts down a manufacturing line. That is not fun! Some times the "Microsoft Tech Support Approach" (reboot server) works and sometimes we find broken data. If you bang on a product long and hard it will break for what ever reason.
>
>Sometimes we like to thing we have the solution which may or may not be true.
>
>Tom