R&R and SQL 2008

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Melissa_B_(Guest)
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

R&R and SQL 2008

Post by Melissa_B_(Guest) » Tue Oct 05, 2010 4:59 pm

We just upgraded to SQL 2008 and when I ran reports today, they had broken. Specifically, the error message I am receiving suggests that any outer joins which I had no longer work. "It is strongly recommended to rewrite the query using ANSI outer join operators." We are on Build 12.1.001. Will this work with SQL 2008? How can I fix the outer joins?____Thanks____Melissa

Terry_(Guest)
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: R&R and SQL 2008

Post by Terry_(Guest) » Fri Oct 08, 2010 10:21 am

Reports should work if you downgrade the compatibility level to 80

Post Reply