HI Paul

Many thanks for the reply I do appreciate it.

1 What were the errors you're trying to fix with repair?

2 Don't you have backups to restore from instead?

3 How big is the database?

1. repair corrupted tables and indexes

2. Actually this is my last backup

3. 4Gig

If you have any dbcc script or defrag can I have it..thanks

Regards

Vincent