Hi,you could also try

UPDATE STATISTICS 'tablename'

with FULLSCAN,

ALL

go

Roy

Hi,

A simpler way too would be to create a table and script the start of a procedure and the end of the procedure , this will notify you how far...

Hi,

If you running SQL2K, SP3a,

Why not create a maintenace job to backup your database and then remove the backup files older than a certain number of days.

These flat files are...

I loaded SP3 and experienced performance issues running my apps.When I loaded SP3a it resolved the performance issues.

I agree with selims.

After SP3a load the MDAC patch to be downloaded from...

quote:

---

sp3a should be used instead as it fixes sp3 installation & slammer issues

---

Cool.

When your syslogs are full run the

DBCC checktable(syslogs)