As I remember it is 1024

Have a good day on Friday.



-----Original Message-----
From: Louis Botes
[mailto:mssqldba-ezmlmshield-x31715231.[Email address protected]
Sent: Friday, August 31, 2007 5:19 PM
To: LazyDBA Discussion
Subject: RE: Max Fields in SQL 2000

Ed, don't start with me on a Friday, I haven't slept much last night and
had even less to drink so I am grumpy and have a hectic deadline waiting
;)

Yeah, I saw this and a max row size of 8036.

So am I correct in saying that it is a total of 1024 columns or 8036
bytes in total depending on what comes first right?

-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x23758301.[Email address protected]
Sent: Friday, August 31, 2007 12:13 PM
To: LazyDBA Discussion
Subject: RE: Max Fields in SQL 2000

Well, well, well!
It's Louis Botes! Hehe. How have you been? Have you tried BOL?
Hehe.


Go into Query Analyzer and click on "Help". Then click on "Contents and
Index". Last, type "maximum capacity specifications" and click
"Display".


Columns per base table 1,024


It's Fridayyyyyyyyy! Partyyyyyyyy! Hehe.

Have a great Day!





Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Louis Botes
[mailto:mssqldba-ezmlmshield-x19940214.[Email address protected]
Sent: Friday, August 31, 2007 5:55 AM
To: LazyDBA Discussion
Subject: Max Fields in SQL 2000

Hi All,



Can anyone tell me off hand what the maximum number of fields are
supported by a SQL Server 2000 table? Is this limited in terms of total
columns or total bytes and what are the limits?



Regards,



L



------------------------------------------------------------------------
------------------
This e-mail was checked by the Verizon Business Internet Mail Content
Filtering Service.

The I M C F provides you with upstream anti-spam and content filtering
and multi layered virus protection.

For more information please contact your Verizon Business account
manager or the sender of this e-mail!!
------------------------------------------------------------------------
------------------



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


----------------------------------------------------------------------------
--------------
This e-mail was checked by the Verizon Business Internet Mail Content
Filtering Service.

The I M C F provides you with upstream anti-spam and content filtering and
multi layered virus protection.

For more information please contact your Verizon Business account manager or
the sender of this e-mail!!
----------------------------------------------------------------------------
--------------



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page