Problem solved, thansk so much. I might write an article about it

Hi and thanks the idea is exactly what I want to do, however, the sp you use is called without parameters. The one I should call is omething like that

create...

Let me be more clear and accurate so you get the image, here is the problem :

Sp1 :

Create SP1

@V1,

@V2,

@V3,

@V4 = 'tempTable' (assigned dynami cally,...

Hi, thanks for your response. The insert is done inside the the SP2 as foolows

SP1 is called with ther 4 params

SP1 'C', 'TEST', 'fdfdfd', 'myTableName',

As you can see the 4th...

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...