Using SQL Server 6.5 ....<br>We are getting illegal outer joins <br>on a restored database ...<br><br>the queries/procs on the original database do work .... <br><br>however the restored database produces these errors ......even after procs and views were refreshed<br>on the restored database<br><br>thanks<br>any ideas ?<br><br>john<br>