Does anyone have any suggestions as to how this issue can be resolved?

I am experiencing the same problem and, whilst there seems to be plenty of people experiencing the problem,...

Thanks again Luke.

Thanks for the advice Luke, i'll have a look at using a matrix instead; i have come across this suggestion during my research into the issue already so it would...

Thanks very much for your advice guys; i'll certainly be sitting down with the developer to go through the code.

I can get the trigger to work by changing the code to the following:

select Inserted.id, Table2.id

from Inserted

left join (select ID from LinkedServer.dbo.Table2) as Table2

on Inserted.id = Table2.id

where LinkedServer.dbo.Table2.ID is...

I'm not joining on a null; i'm performing a left join on the ID column.

A left join returns all rows from the left table, even if there are no matches...

Thanks for your help so far.

I chose snapshot replication because our reporting database needs to be a snapshot of out live database taken at the start of each working day....

Okay thats great, thanks very much for your prompt response.