Replication

[kiran]

I need to perform replication on two machines where in i have 54,000 tables out of which i need replicate 25 tables is there any way where i can rathere than selecting tables from the huge list just specify the required tables, could any one please guide me through this.

What is the impact of this on performance.

Thanks a lot for your help.

I appriciate this very much.

[chakri]

Try sp_addarticle. For this, you need to first create the publication without specifying any tables. And then add the tables using sp_addarticle. Check BOL for syntax.


------------
kiran at 3/8/01 6:13:31 PM


I need to perform replication on two machines where in i have 54,000 tables out of which i need replicate 25 tables is there any way where i can rathere than selecting tables from the huge list just specify the required tables, could any one please guide me through this.

What is the impact of this on performance.

Thanks a lot for your help.

I appriciate this very much.