I have thried to open then in note pad but it shows up as mostly garbage. Could be a binary file.

Turns out it wasn't being truncated, it was pointing to the wrong database id due to quoted identifiers being set off, set them on and all is good. Thanks

...

Hi, We were using parallelism on all our SQL 7.0 servers until we were live for about a year. I think (and this is only my own opinion) that...

Hi, not sure if this will help or really be what you are looking for but have you thought about creating a 'Common' database to house tables that are referenced...

Hi, This is an odd error, just my thoughts but it sounds like the error is occurring when the reindex job is re-writing the data pages to the data file...

Thanks jpipes. Did you go to MDAC 2.7 when you upgraded your environment?

What actions do you have selected in the Job step, advanced tab? the ones I mean are the "upon success action" and "upon failure action".

Yeah, that is what I thought too. But I have dropped and re created indexes thinking that the auto stats would take care of it. What happened was...

I'm using a SQL 7.0 cluster and profiler does not work properly when attempting to run against the cluster, it causes a fail over. I do monitor the processors...

Thanks.

Thanks, do you know if there is a way that I can log the stats also?

Thanks

E...

When we had it turned on we were on Sp3, It worked somtimes and then other times it didn't, I would guess it sounds like it may have got...

I can't really answer all of the questions but I may be able to provide some insight. Using the MaxDop1 hint in your query forces SQL Server to use...

Thanks, I understand now.

Thanks folks, I do require that any proc changes get updated in the header but you know how it goes, some times people are in a hurry and they no...