SQL Server 6.5 and 16 Table Limit 
Author Message
 SQL Server 6.5 and 16 Table Limit
Sorry, You have to live with this :-(

It's a design thing about SQL server

Eric Gentz schrieb in Nachricht ...

Quote:

>I am writing a query against a SQL Server 6.5 database and I am receiving
>the error that the 16 table limit has been reached. Is this something that
>I have to live with or can something be changed on the database server?

>Thanks,

>Eric





Sat, 01 Sep 2001 03:00:00 GMT
 SQL Server 6.5 and 16 Table Limit

Eric,

I think you've got your answer from the others.  I _gather_ that the
limitation also extends to Foreign Keys per table (although I thought
the limit was 31).

Neil's answer is (as always) comprehensive and well informed.  I would
take issue with him, though, that "if a query needs more than 16
tables then you have a very bad query and/or database design": the
nature of the design depends on the nature of your application.  It
_is_ true to say that one reason you may need to join a lot of tables
is that you have a busy core table with a lot of look-up tables.  If
this is the case and you have the freedom to make these kinds of
changes, you can look at "de-normalising" the look-up tables by
placing several tables with a similar structure in the same physical
table.

Len

Quote:

>I am writing a query against a SQL Server 6.5 database and I am receiving
>the error that the 16 table limit has been reached. Is this something that
>I have to live with or can something be changed on the database server?

>Thanks,

>Eric





Sun, 02 Sep 2001 03:00:00 GMT
 SQL Server 6.5 and 16 Table Limit
Leonard,

 Maybe I should stick a "probably" in there.....

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp



Mon, 03 Sep 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL Server 6.5 16 table limit?

2. 6.5 - 16 table limit in SELECT

3. 16 Table Join Limit in 6.5

4. SQL Server 16 table limit

5. 16-table Limit in SQL Queries

6. NT Workstations running the 16-bit I/SQLW cannot connect to SQL Server 6.5

7. ODBC 16 BIT for MS SQL Server 6.5

8. ODBC 16 bit and SQL-SERVER 6.5 with WIN3.11

9. Is SQL Server 6.5 a 16 Bit Aplication?

10. Connection errors with Visual Basic 4 16-bit and SQL server 6.5 on a 3.11 platform

11. PROBLEM: Accessing SQL SERVER 6.5 from 16 bit ODBC Application (VC++ 1.5)

12. 16 Tables involved in query Limit


 
Powered by phpBB® Forum Software