Maximum table joins

[shyamal]

Anyone know what the maximum table joined can be on SQL2K?

Thanks in advance.

 

[tlbroadbent]

256 tables

Maximum Capacity Specifications

http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[shyamal]

This seems to be the number of files in a db, does not specify how many joins one can create?

 

[tlbroadbent]

No, you can create over 2 billion objects in a database. You could have millions of tables if you wanted. You can include 256 tables in a single query. However, do to other considerations the real limit may be fewer tables. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.