MS SQL Server, 16 tables limit

Michael Führe
#1 / 5

16 tables limit

Has the sql-server 7.0 the limit of 16 tables in a statement.

Michael Fhrer

Mon, 21 May 2001 03:00:00 GMT

Tibor Karasz
#2 / 5

16 tables limit

Michael,

It's upped to 256 :-)

--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please do not respond by e-mail unless explicitly asked for.

Mon, 21 May 2001 03:00:00 GMT

Elton Serafi
#3 / 5

16 tables limit

The limit is 32 table in SQL 7.0
Consult : www.microsoft/com/sql
or contact me

----------------------------------------------------------------------------
----------------
Elton de Souza Serafim
Ernst & Young Consulting

----------------------------------------------------------------------------
----------------
Michael Fhrer escreveu na mensagem ...

Quote:

>Has the sql-server 7.0 the limit of 16 tables in a statement.

> Michael Fhrer

Wed, 23 May 2001 03:00:00 GMT

Neil Pik
#4 / 5

16 tables limit

Elton - it's 256

Quote:

> The limit is 32 table in SQL 7.0
> Consult : www.microsoft/com/sql

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
For SQL FAQ entries see www.ntfaq.com/sql.html
and http://www.swynk.com/friends/hotek/articles/sqlserverfaq.asp
and GO MSSQL lib 1 on Compuserve

Wed, 23 May 2001 03:00:00 GMT

Blitt
#5 / 5

16 tables limit

On Sat, 05 Dec 1998 21:40:57 GMT, Neil Pike

Quote:

>Elton - it's 256

>> The limit is 32 table in SQL 7.0
>> Consult : www.microsoft/com/sql

> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please post ALL replies to the newsgroup only unless indicated otherwise)
> For SQL FAQ entries see www.ntfaq.com/sql.html
> and http://www.swynk.com/friends/hotek/articles/sqlserverfaq.asp
> and GO MSSQL lib 1 on Compuserve

I think this is a FAQ, but how do you make views with more then 16
tables ?

Greetings !

Mon, 04 Jun 2001 03:00:00 GMT