sorry that should read

'As I am attaching.......

just to answer your question... all my tables are in one DB that I am migrating..

As I am detaching the DB to a new server (2000 to 2005 migration), Perry Instructed me to do the following tasks after the migration:

- dbcc updateusage

- create index

-...

If I use 'update statistics' when I detach the database, do I still have to run the update statistics after I attaching the DB.

Is there a way to create...

Thanks again, I hope to do tomorrow/ or monday, and let you know how it went.

Hi Perry, Could you pls let me know whether I have to run restore the logins prior to restoring the user data bases or the order doesn't matter?

Also when I...

Thanks Perry for your quick response, I have been gathering information for some time before I made my plans, but postponing the migration for sometime, however your approval gives me...