πŸš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: bit.databases.mssql-l
Article #50

Re: More than 250 Columns in a view.

#50
From: bruno reiter
Date: Fri, 14 Jan 2000 00:00
26 lines
1750 bytes
verify sp_dbcmptlevel

HTH

bruno reiter

Enrique Sanchez <ejsm@proinfo2000.com> a οΏ½crit dans le message :
85n4t9$o9h$1@diana.bcn.ttd.net...
> Is there any way of creating a view with more than 250 columns in SQL
Server
> 7.0?
>
> I know there's a limit in tables of 1024 columns.
> Is the same limit in Views?
>
> Do I have to change something in the server configuration?
>
> Thanks in advance!
>
> Javier.
> jdm@proinfo2000.com
> Spain.
>
>
>
>
Technical Details
Message-ID: <ONRwCIpX$GA.237@cppssbbsa02.microsoft.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <85n4t9$o9h$1@diana.bcn.ttd.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 111a5a,2ac45b769c61e186
X-Google-Attributes: gid111a5a,public
X-Google-Thread: f6611,2ac45b769c61e186
X-Google-Attributes: gidf6611,public
X-Google-Thread: 109585,2ac45b769c61e186
X-Google-Attributes: gid109585,public
X-Google-Thread: 106afd,2ac45b769c61e186
X-Google-Attributes: gid106afd,public
X-Google-Thread: 106e2f,2ac45b769c61e186
X-Google-Attributes: gid106e2f,public
X-Google-Thread: 104de1,2ac45b769c61e186
X-Google-Attributes: gid104de1,public
X-Google-Thread: f4a41,2ac45b769c61e186
X-Google-Attributes: gidf4a41,public
X-Google-Thread: 1025cd,2ac45b769c61e186
X-Google-Attributes: gid1025cd,public
From: "bruno reiter" <br33@multimania.com>
Subject: Re: More than 250 Columns in a view.
Date: 2000/01/14
Message-ID: <ONRwCIpX$GA.237@cppssbbsa02.microsoft.com>
X-Deja-AN: 572550092
References: <85n4t9$o9h$1@diana.bcn.ttd.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-MSMail-Priority: Normal
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,es.comp.bd.misc,es.comp.bd.ms-access,es.comp.lenguajes.delphi,es.comp.os.ms-windows.misc,microsoft.public.de.sqlserver,microsoft.public.fr.sqlserver,microsoft.public.sqlserver.clients,microsoft.pu