Also I want to add that when you have several articles when there is an sync error,

SQL doesn't indicate exactly which table is halting the whole replication.

In case you have...

This is the conclusion I arrived after reading the BOL.

What I wanted to say is instead of a script created manually for each table, why MS didn' MS added a...

I will try to be more clear.

What I would like to know if it is possible to sync the subscriber without dropping anything because I have an ebusiness...

Hi and Thanks. First, Yes I want replication to fail on error.

Second, I tried the option Reinitializ all, I get the following message displayed :

-------------------------------------

This will mark the subscriptions that...

Hi, I am trying populate a temporary table by a SP as follows

Insert Into #test execute PEP_GetPromotion 'C ', '009904ML', '130', 'P0', 'Search_ProdHome101234_38483', 'P'

I always get the following error...

Very nice article. I I think it would be a god idea to create a template for stored proc, at the end of it's creation it grants permission for db_executor...