I would move the delay statement after the COMMIT otherwise you will be holding the lock for too long!

...

WHILE @x > 0

BEGIN

 BEGIN TRAN

 delete from events

        where datediff(day, EVENT_DATE, getdate()) >...

OK,

To delete those rows just disable the triggers on that table (hopefully you have only the merge triggers in there  you should verify it! and...

What Hilary was implying is that you MUST setup a filter to solve the problem

Cheers

[Edit]: Oh and yes, SiteID seems like a good candidate for it

well this is a new one for me because if you have PK constraint violated seems like a serious flaw in the engine (which I don't believe such thing can...

what happen when you stop and re-start your merge agent?

are you sure you can see by name and by IP the subscriber from the publisher ?

I'll go for merge in this case!

Barbara,

I am sorry couldn't get back to you sooner.

What you can do is to schedule a job with sp_mergemetadataretentioncleanup if you need to run it continuous mode.

Ah... didn't read well that the string was missing the day part!

I would:

select

   year(cast(field as datetime))

 , month(cast(field as datetime))

 , day(cast(field as datetime))

from <yourtable>

hth

I personally think a cursor is not necessary for this operation and the job can be performed entirely in the temp table. Once that's done is a matter of single insert...

That's a nice try but:

• Trucate will Log Page deallocation
• Truncate Requires Elevated Priviledges
• Truncate can't be executed if the table has foreign keys
• Truncate will LOCK the users out so if you try...

For Transactional:

Have a look  at sp_browsereplcmds

For Merge thereis an script by Paul Ibison posted here

HTH

Barbara,

I believe that where you are  confused is on the sp. There are two sp.

1) sp_mergecleanupmetadata

2) sp_mergemetadataretentioncleanup

The First should be used for topologies with SQL Server 2000 SP1 or less...

Ok, This "image Feature" does not works  (as I assumed )

so lets try describing it:

once you have stablished the data transformation task between...

do you see this