Answere for question number 3:

You can define an article with query 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..)


--- amir krugliak <[Email Address Removed] wrote:
> 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
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


=====

Best Regards,
Bajal Mohamed.

Mobile : + 673 + 8611056

Time and tide wait for none






__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
MS Sql Server LazyDBA home page