Hi Paul,

THANK you very much for your reply and your link. It is exactly what I need. I really appreciate your great help!

I will create the scripts for my case...

Here is the detail info

We are in a project to migrate currently source sql server 200sp4 of A server for QA and B server for PRD in location L1 to...

I have anotehr question continue with data transfer (or database clone) from 2000sp4 to 2005sp3:

I have big list of databases (more than 30 databases) need to be cloned from...

Hi GilaMonster,

Thanks for your info. I appreciate your help.