I had similar issue and I found that in my case, it was due to the fact that SQL 2005 automatically checkmarks "Optimize for many tables" if you select more...