Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    San Jose, CA
    Posts
    3

    Unanswered: Max number tables can join for sql server2000

    Hi,
    Does anybody know the max number of tables can join when performing a query in WHERE clause for sql server2000 ?
    Can't find this information from the internet. Thanks !

    Philip

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I believe the max number is 32. I remember it was a big deal when SQL 7.0 brought this limit up from 16 for SQL6.5, but I don't remember it being upped in SQL 2000.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •