Column limit

Is there a limit on the number of columns you can create in SQL Server?
I keep hearing 250 but I can't find anything definate.
KenBOL: Maximum Capacity Specifications
Columns per base table: 1024
KenH wrote:
> Is there a limit on the number of columns you can create in SQL Server?
> I keep hearing 250 but I can't find anything definate.
> Ken
>|||On 9 Sep 2005 13:10:51 -0700, KenH wrote:

>Is there a limit on the number of columns you can create in SQL Server?
>I keep hearing 250 but I can't find anything definate.
>Ken
Hi Ken,
Did you check Books Online? In the index, "Maximum number of columns per
table" points to the description of CREATE TABLE, where (under the
heading "Remarks") it says:
(...)
And the index entry "maximum capacity specifications" takes you to a
table that lists the same number, plus much more information.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Thanks guys!
I'll start using the books online.
Ken