Hi David,

Thanks for the help.

But i have a question that i had never done this before. Can you tell me the steps if so.(snapshot replication and copy database)

Also the database i want to copy in local server have to be copied some particular tables , there are around 80 tables , in which 20 tables need to be moved in the local server

And then i can use snapshot replication.

I was trying to copy the database but it was allowing me copy the full database not letting me select particular tables from that database

thanks