Wednesday, March 28, 2012

Outer joins fail since adding replication

I have an application that has been using a right outer join that worked as I
expected until I added merge replication. On the replicated database the
result is the same as an inner join. I could be doing something odd but it's
a pretty plain use and it still works on instances of the database without
replication. I thought I'd first ask if this is a known issue before creating
small standalone files for posting.
Thanks
Kohn,
I see no reason how this could possibly be an issue. Please can you post up
your files and I'll try to repro.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment