Any check on the antivirus which could block the service to run?Did you disallowed your antivirus to scan the data files by the way?

Did you allowed statistics setting on your dB?Check settings on your dB related to statistics growth

HTH

Try to run a profiler when running your procedure in order to see which part of your sp is resource consuming.

Hope this helps

By the way Group by is known to...

Well,Nobody talked here about the costs.This is another reason for companies not upgrading now to another SQL release.

But anyway,i believe there's also a need to keep the technological wakefulness so,not migrating...

Thanks Paul!

Hi,

Backup the transaction log and truncate it.You'll save some place onto your server and all pending active transaction will be validated and all inactive will be truncated.