I cant set the OPTION(FORCE ORDER) in the IF EXISTS clause

In the SELECT only Statement ist works fine

SELECT * FROM dbo.ATEMP_tblExportArchiv ATEA INNER JOIN dbo.tblExportArchiv AEA ON ATEA.EA_GUID = AEA.EA_GUID...

Hehe a little error in reasoning,

your right, thx for the broad hint

but thats not the real cause. I want to know why it doesnt work?

In the actual situation its...

SELECT * FROM table ORDER BY column DESC

Hi Jack,

thx for the answer.

the reason why i used this structure is, that i think an INSERT without WHERE (1st Statement) clause is faster than an INSERT with...

I'm sorry, but *.sqlplan is a not permitted type, so I packed both Files in a *.zip File.

tblExportArchiv (841142 Sets) is the Archiv Table - tbl1

ATEMP_tblExportArchiv (217716 Sets) is...

thx for the answer

Theres no improvements if i change NOT EXISTS clause to EXISTS. For simplification i replaced the INSERT Statements with PRINT's and still get the high duration

For drop article from the subscription you need to execute:

1. sp_dropsubscription

2. sp_droparticle

For adding the article after update

1. sp_addarticle

2. sp_refreshsubscriptions

to add the article you can also take the enterprise Manager...

thx for the answer,

but thats not the way we want to go, because the same replication works by other customers.

I thought while the snapshot agent runs the tables are locked...