How, pleas

Then i ave to add, change, delete records ever ... seconds

Or every ... seconds truncate this table and refill it

Thank you

Chris Vandewiele

Dear

I allready set up replication of an indexed view. It creates a new table (same layout as the indexed view) in the subscriber database.

So that works perfectly.

Now...

i taught it was the best to use the replication software of sql server itself.

It works perfectly with indexed views if i do not use left joins

So i taught it...

i want to replicate fields out of 4 5 tables that are joined with 'left joins' and want that the replication creates a new table at the subscriber site with...

I tried this below but it gives another error

ALTER VIEW [dbo].[vwReplEmptyProvisionsHomeTerminal4] with schemabinding

AS

(

SELECT dbo.Berthings.Berthing_id,

...

Hi,

Another question follows :w00t:

now i want to use a stored procedure to insert a record in table t_order with this instead trigger

INSERT t_order (

date_document

, description...

yes it works

sorry the insert in t_order i didn't seen

perfect

Thank you

Wheel 😉

No almost,

in t_order_his is now one record

but in t_order there is no record because of instead of trigger.

This insert in t_order has to happen ??

Other suggestion??

Thank you

Wheel

Hi

This stays a problem.

- insert in t_order

I want that the for insert trigger tr_logging_i_order creates 1 record with trigger_mode 'I' (insert) in table t_order_his.

But because in the...