Maximum number of Tables in a Join error

I am trying to make new relations that table which already have high number of relations defined on it Like “InventTable”. On showing the field I am seeing a warning message that “The table exceeds the max join limit…”

Someone provide me detailed solution which can help me to overcome this problem.

Harsh Raj,

www.techcronus.com

Welcome to DUG!!!

You can chcek following link

http://stackoverflow.com/questions/2558667/what-is-the-maximum-number-of-joins-allowed-in-sql-server-2008