hi

i have a few question regarding transactional replication.

1)is there a way to replicate data between two DB from tables with different names and maybe structure.

2)i looked inside the replication properties and found out that the snapshot agent run default procedure for insert,update and delete statment.where those stored procedure is sitting?
their names are:
sp_MSins_campaign_ETPst
sp_MSupd_campaign_ETPst
sp_MSdel_campaign_ETPst

3)is there a way to run a query during the replication in order to replicate only the data that match with the query criteria.(such as join statement etc..)

--
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

MS Sql Server LazyDBA home page